NPV - Variable Cashflows

[andersonbda]

I have a report with varying lengths of Cashflows. How do I make a formula calculate the NPV where I can just paste next to the cashflows and it will automatically calculate the appropriate range based on the term.

Lets say Initial cost is in A1, rate is B1, equation is C1, and cashflows begin in A2.

Thank you!

 

[Firefly2012]

Hi

I'm afraid I'm not really following what you want - can you post a full examle showing current data and expected results?