andersonbda
New Member
- Joined
- Dec 4, 2011
- Messages
- 14
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!
Lets say Initial cost is in A1, rate is B1, equation is C1, and cashflows begin in A2.
Thank you!