Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Location
    Seattle, Washington, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cannot evaluate formulas in Excel (2003)

    I have a user with a problem that has stumped us all.
    If you open a brand new spreadsheet and type =if(0=0, 1, 0) and press enter, you receive the error message "The formula you have typed contains an error." The Insert Formula command does the same thing. If you open an existing spreadsheet created on another machine and edit a formula that worked on the other machine, you get the same error. Does anyone have any suggestions for how I might troubleshoot this?
    Thanks, Tsukina

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot evaluate formulas in Excel (2003)

    Does the user's system have the English-language version of Excel installed, or a foreign-language version?
    Does the user's system use American English settings? For example, point as decimal separator and comma as list separator? If it uses continental European settings (comma as decimal separator), the formula you mention would cause an error.
    If the above doesn't apply, take a look at Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  3. #3
    New Lounger
    Join Date
    Jun 2004
    Location
    Seattle, Washington, USA
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot evaluate formulas in Excel (2003)

    Hans, Thanks for the advice. She had English XL, English Windows and standard US separator settings. We walked through the systematic approach document. We finally determined that while it did not happen under the generic user login on her windows account, if you create a new login on windows, it occurs (XP Professional). We reinstalled windows. No avail. We've gone to the big hammer and are going the fdisk route. Thanks, Tsukina

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •