Microsoft KB Archive/212199

= XL2000: List of Errors That Formula AutoCorrect Detects =

Article ID: 212199

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212199





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



MORE INFORMATION
   Error                             Example           Result Unmatched parenthesis in      non-nested formulas             =A1+(A2+A3        =A1+(A2+A3)    Unmatched curly braces {}         ={1,2,3}*{1,2,3   ={1,2,3}*{1,2,3}    Unmatched quotation marks     " " or ' '                       ="asdf            ="asdf"    Reversed Cell References          =1A+1B            =A1+B1

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

Extra operators in the beginning of a formula         ==A1+B1           =A1+B1 Extra trailing operators without operand                =A1+B1+           =A1+B1 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     separator as determined by      Regional settings in      Windows Control Panel)          10,000.00         10000.00 Operator Order                   =A1=>B1           =A1>=B1 =A1=B1 Misplaced colon in range         A:1:B2            A1:B2 Using semi-colon in range        A1;B2             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 name and parenthesis           =SUM (A1:B2)      =SUM(A1:B2)

