@npv

  • Thread starter Thread starter michael slater
  • Start date Start date
M

michael slater

I am using Excel 2003.

When using @npv function, I get the error message "You've
entered too few arguments for this function"

Anyone experienced this or have any ideas.

Michael
 
Hi Michael!

=NPV(rate,value1,value2, ...)

Returns the net present value of an investment based upon a series of
periodic cash flows and a discount rate where the first cash flow is
received at the end of the first period

Rate is the discount rate
value1, value2 etc. 1 to 29 possible values

Most often we would only enter a single range of values and the
function might look something like:

=NPV(10%,A1:A30)
 
Back
Top