| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A function to get a variable row reference for range in XNPV funct
I want to use the formula below to calculate the NPV of a future stream of
payments based on the start date entered by the user in another cell on another tab of the worksheet. I can't seem to get the # portions of the formula below replaced with a function combination that does not result in a text string with quotations embedded which then results in an error in the NPV formula. Suggestions? =XNPV(N3,Q#:Q190,N#:N190) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Performing a function on a column of variable length | Excel Worksheet Functions | |||
| IF function: Reference cells - Value vs Formula | Excel Worksheet Functions | |||
| IF Function - If the reference cell data is presently unknown | Excel Worksheet Functions | |||
| how do i use the function to copy and paste a determined variable. | Excel Worksheet Functions | |||
| Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
Threaded Mode
