Hi :)

Please, try this:


NPV(ir,OFFSET(C2,0,0,1,A5) )

Whe
ir: Is the interest rate, or a reference to the cell that contains the
interet rate.
c2: Initial reference for the initial year of the returns.
A5: Reference to the cell that contains the number of years to
consider.

Hope it helps!

Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=377432