Microsoft KB Archive/191891

= XL98: List of Errors That Formula AutoCorrect Detects =

Article ID: 191891

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191891





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

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: kbinfo KB191891

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.