LinkBack URL
About LinkBacks
Hi,
First post!
I want the values in NPV formula to be volatile as I specify the start date and end date.
So, the formula could be =NPV(5%,N5:T5) or =NPV(5%,F5:L5) depending on start and end date I would have specified in two distinct cells.
Thanks.
Hi,
First post!
I want the values in NPV formula to be volatile as I specify the start date and end date.
So, the formula could be =NPV(5%,N5:T5) or =NPV(5%,F5:L5) depending on start and end date I would have specified in two distinct cells.
Thanks.
Welcome to the forum.
Using your posted workbook, this formula returns the NPV for the referenced range:
Is that something you can work with?
Please Login or Register to view this content.
See the attached file with index/match and indirect.
Please add the formula on the forum, for the benefit of all.
I don't know all translations (at the moment).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Yes, that works. I didn't think of trying INDEX-MATCH on either side of the :
I thought I would need INDIRECT...
Many thanks!
Glad you got something you can use!
If that resolves your issue, please take a moment to mark this thread as SOLVED (from the Thread Tools menu)
BTW....You can use INDIRECT in your situation, but that function is volatile. That means whenever any cell in the workbook recalculates all cells containing volatile functions also calculate. The end result is often sluggish workbooks. Consequently, I only use them when there's no practical alternative.
Last edited by Ron Coderre; 07-24-2015 at 04:25 PM.
In that case I would appreciate if you also comment on the solution in #3.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks