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

Discussion in 'Microsoft Excel Crashes' started by Guest, May 1, 2005.

  1. Guest

    Guest Guest

    That is what the program gives me when I input a formula like KNPV or IRR.
    Any ideas how to fix? thank you
     
    Guest, May 1, 2005
    #1
    1. Advertisements

  2. Hi Roger,

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


    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
     
    Jan Karel Pieterse, May 2, 2005
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jan Karel Pieterse

    Re: What does this mean. How can it be fixed

    Jan Karel Pieterse, Sep 25, 2003, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    496
    Jan Karel Pieterse
    Sep 25, 2003
  2. Guest

    what does :2 mean?

    Guest, May 23, 2005, in forum: Microsoft Excel Crashes
    Replies:
    1
    Views:
    180
    Rob Bovey
    May 24, 2005
  3. Guest
    Replies:
    0
    Views:
    894
    Guest
    Jun 1, 2005
  4. Guest
    Replies:
    1
    Views:
    357
    Nick Hodge
    Nov 5, 2007
  5. MAF

    What does the "fix the middle" error mean in Excel?

    MAF, Mar 18, 2008, in forum: Microsoft Excel Crashes
    Replies:
    0
    Views:
    193
Loading...

Share This Page