Most valuable professional
  • Hot Topics

Excel Formula That Takes Into Account Position Within a Table

Hi Everyone, I am trying to create a single formula that I can autofill into a table that will take into account different starting and ending quarters, along with duration. In addition, it need to have a variable rate depending on duration and starting/ending quarter. Is this possible? I have tried nesting IF statements and I have looked through the built in financial functions, but no luck. Image included for clarity. Thanks guys! Mort

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of May 27, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel