If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled range. Simply reference the first cell of the spilled range with a # ...

An inverse floater’s coupon rate moves inversely with a benchmark rate, adjusting payments as interest rates change. These financial instruments are often issued by governments or corporations to ...

David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.