XL98: List of Errors That Formula AutoCorrect Detects

• Microsoft Excel 98 Macintosh Edition

SUMMARY

This article contains a list of common formula errors detected as part of the Formula AutoCorrect feature of Microsoft Excel 98 and the suggested correction for each error.

MORE INFORMATION

 Error                             Example           Result
 --------------------------------------------------------------------

 Unmatched parenthesis () in       =A1+(A2+A3        =A1+(A2+A3)
   non-nested formulas

 Unmatched curly braces {}         ={1,2,3}*{1,2,3   ={1,2,3}*{1,2,3}

 Unmatched quotation marks         ="asdf            ="asdf"
  " " or ' '

 Reversed Cell References          =1A+1B            =A1+B1

 NOTE: R1C1 and absolute referencing with reversed cell references
 are not automatically fixed.

 Extra operators in the            ==A1+B1           =A1+B1
   beginning of a formula

 Extra trailing operators          =A1+B1+           =A1+B1
   without operand

 Double operators                  =A1*/B1           =A1*B1

 Implied Multiplication            =A1+2(3/B2)       =A1+2*(3/B2)

 Replace x with *                  =2x3              =2*3

 Extra decimal points              123.456.789       =123.456789

 Commas as separator (or          =2*10,000.00      =2*10000.00
   separator as determined
   by Numbers setting in
   Control Panels)

 Operator Order                    =A1=>B1           =A1>=B1
                                   =A1=<B1           =A1<=B1
                                   =A1><B1           =A1<>B1

 Misplaced colon in range          =SUM(A:1:B2)      =SUM(A1:B2)

 Using semi-colon in range         =SUM(A1;B2)       =SUM(A1:B2)

 Extra spaces in cell addresses    =A 1+B2           =A1+B2

 Extra space between numbers       =1 + 2 + 3        =1+2+3

 Extra space between function      =SUM (A1:B2)      =SUM(A1:B2)
   name and parenthesis 

Additional query words: XL98 auto-correct

Keywords : kbdta xlformula
Version : MACINTOSH:98
Platform :
Issue type : kbinfo