Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
View products that this article applies to.
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)
Keywords: KB212199, kbinfo