Home |
Search |
Today's Posts |
#1
|
|||
|
|||
referencing cols in functions - NPV
I have an NPV calculation where I want to be able to change the number of years for the NPV calculation by inputting different numbers into a single cell (instead of having to change the range in the NPV formula each time). I have the years 1-8 in range C1:J1 and the yearly returns in C2:J2. In A2 I have =NPV(8%,C2:J2). I want to use a cell (say A5) reference instead on "J2" in this function. So, if I enter 8 in A5 the NPV will sum the investment for 8 years Can somebody help? DesM -- DesM ------------------------------------------------------------------------ DesM's Profile: http://www.excelforum.com/member.php...o&userid=24121 View this thread: http://www.excelforum.com/showthread...hreadid=377432 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PASTE DOWN FUNCTIONS | Excel Worksheet Functions | |||
how do i flip a column round in excel? | Excel Discussion (Misc queries) | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
Functions referencing unopened workbooks | Excel Worksheet Functions | |||
# of Functions per cell | Excel Worksheet Functions |