@npv

[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

 

[Norman Harker]

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)