"Error In Formula" or Incorrect Calculation Entering Formula

• Microsoft Excel for Windows, versions 2.1, 3.0, 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a

SYMPTOMS

In Microsoft Excel, when you enter a formula in a cell on a worksheet, the formula may return an incorrect value, or you may receive the following error message:

Error in formula

CAUSE

This behavior occurs if the character that you use to separate values in your formula is different from the character that is entered as the list separator in the International dialog box in Microsoft Windows. For example, if you use a comma to separate values in your formula, and the list separator is set to a hyphen (-) character, you receive the error message above when you enter the formula on the worksheet.

WORKAROUNDS

• Method 1: When you enter a formula on a worksheet in Microsoft Excel, use the list separator character that is set in the International dialog box in the Control Panel.



• Method 2: Do the following to change the list separator in Windows:
  
  In Windows 3.x:
  1. From the Main group in Program Manager, run Control Panel.
  
  
  
  2. Double-click the International icon.
  
  
  
  3. In the List Separator box, enter the character you want to use as the list separator, and choose OK.
  
  
  
  In Windows 95:
  1. On the Start menu, click Settings, then click Control Panel.
  
  
  
  2. Double-click the Regional Settings icon.
  
  
  
  3. Click on the Number tab.
  
  
  
  4. In the List Separator box, enter the character you want to use as the list separator, and choose OK.
  
  
  

The list and decimal separators specified by the system are identical. Substituting ';' for the list separator.

Additional query words: 4.00a 5.00c

Keywords : xlwin
Version : 2.10 3.00 4.00 4.0a 5.00 5.00c 7
Platform : WINDOWS
Issue type :