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
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