In Excel, what does the message "#NAME?" mean?

G

Guest

That is what the program gives me when I input a formula like KNPV or IRR.
Any ideas how to fix? thank you
 
J

Jan Karel Pieterse

Hi Roger,
That is what the program gives me when I input a formula like KNPV or IRR.
Any ideas how to fix?
Click to expand...

It is what Excel shows when it does not recognise a function or defined name.
E.g. when you enter an English function into a Dutch Excel version. Or when
you enter a function from the Analysis Toolpak Add-in (tools, add-ins) and the
add-in is not checked.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sensitivity (What If) analysis 1
IRR & Address Formulas 2
data table - hmz - 2nd posting because could not find the first on 1
data tables - (not pivot) 1
Data Table 4
finding the results of changing 4 variables 3
IRR Problem 2
Working with arrays as arguments 6

Top