Article ID: 161747
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q161747
SUMMARY
This article contains a list of common formula errors detected as part of the Formula AutoCorrect feature of Microsoft Excel 97 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 =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)
REFERENCES
For more information about AutoCorrect in formulas, click the Index tab in Microsoft Excel 97 Help, type the following text
formula autocorrect
and then double-click the selected text to go to the topic.
Additional query words: 97 XL97 8.00 auto-correct
Keywords: kbinfo kbualink97 KB161747