XL2000: List of Errors That Formula AutoCorrect Detects (212199)

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           =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)