NPV Function

  • Thread starter Thread starter Michael Slater
  • Start date Start date
M

Michael Slater

When i follow the correct process entering data I get a
message "you've entered too few arguments for this
function"

When I follow the exact same process on another machine I
get the correct answer.

Any suggestions?
 
You've stated that you follow the correct process entering data, but
get an error message.

That's not nearly enough to go on to make even a wild speculation.
About the only useful advice anyone could give is: Look at Help for
the function or functions you're using and enter the correct number
of arguments. Or perhaps: Check your parentheses.

If you want someone to help you figure out what's going on, you need
to tell us what you've tried to enter. It's obviously *not* correct,
so we'll need to see the exact formula you've written in order to
help you correct it.

AFAIK, there are no functions in XL that are machine/version
dependent for their argument list, so you might also go back and
really look at the one that is successful and see if you can find
the differences. From your description, I can't tell if you're using
User Defined Functions or not - that might vary if the UDFs are not
contained in the same workbook and therefore could be different
versions.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm
 
Hi Michael,

I have the same error at this moment. Did you already find a solution?

Marieke
 
Hi Marieke!

NPV as a very simple structure and only requires two arguments:

=NPV(rate,value1,value2, ...)
Example:
=NPV(10%,10000,10000,10000)
Returns: 24868.5199098422

But typically we use a single range for the cash flows:

=NPV(10%,A1:A18)

Check what you have used against the above.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top