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! [I]Mort[/I] [IMG]http://i.imgur.com/xe3oJMp.jpg[/IMG]

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