I'm trying to create a formula that calculate the NPV from a given cell reference along a row for x number of cells.
ie. my formula is =NPV(2,B32:x32)
The number of cells I want to calculate it for (x) is contained in B40.
ie. if I have the number 10 in B40 I want to calculate the NPV from B32:K32 (10 columns along from B32).
I've fiddled with the indirect, match, address formulas with no luck so far.
Are there any suggestions how to approach this?
ie. my formula is =NPV(2,B32:x32)
The number of cells I want to calculate it for (x) is contained in B40.
ie. if I have the number 10 in B40 I want to calculate the NPV from B32:K32 (10 columns along from B32).
I've fiddled with the indirect, match, address formulas with no luck so far.
Are there any suggestions how to approach this?