“Formula parse error” means Google Sheets could not read your formula as valid syntax, so it never calculated it. The cell shows #ERROR!, and pointing at it shows the message Formula parse error. The cause is almost always a typing problem: a missing bracket, a quote that is not closed, curly quotes copied from a website, or the wrong separator for your spreadsheet’s locale.
Tested in Google Sheets. Every broken formula on this page was entered in Google Sheets on November 10, 2026, in spreadsheets set to the United States and to Spain, and the error shown is the one Sheets returned. How we test
Want to skip the reading? Paste your formula into our free formula checker: it points out unclosed brackets and quotes and converts between comma and semicolon separators.
The causes at a glance
| Broken formula | What is wrong | Fixed |
|---|---|---|
=SUM(1,2 |
Missing closing parenthesis | =SUM(1,2) |
=SUM(1,2)) |
One parenthesis too many | =SUM(1,2) |
=IF(A1="x,1,0) |
Text in quotes is not closed | =IF(A1="x",1,0) |
=IF(A1=“x”,1,0) |
Curly quotes instead of straight quotes | =IF(A1="x",1,0) |
=SUM({1,2)} |
Brackets closed in the wrong order | =SUM({1,2}) |
=A1+ |
Ends with an operator | =A1+B1 |
=SU M(A1:A3) |
Space inside the function name | =SUM(A1:A3) |
=@A1 |
Excel’s @ operator | =A1 |
=SUM(1,2) in a spreadsheet set to Spain |
Commas instead of semicolons | =SUM(1;2) |
1. Brackets that don’t match
Every ( needs a ), and every { needs a }, closed in the reverse order you opened them. In long formulas, count the opening and closing brackets, or paste the formula into the checker, which reports how many are missing.
An empty argument is not a parse error. =SUM(1,,2) returned 3 in our test.
2. Text quotes that are not closed
Text inside a formula goes between double quotes, and each quote needs a partner. =IF(A1="x,1,0) leaves the quote open, so Google Sheets reads x,1,0) as part of the text and the formula never ends. To put a quote character inside a text, write it twice: ="He said ""hi""".
3. Curly quotes copied from a website or document
Word processors and many websites turn straight quotes (") into curly ones (“ ”). They look almost identical, but Google Sheets only accepts straight quotes. If a formula copied from an article fails, retype the quotes in the formula bar. The same applies to curly apostrophes (‘ ’) around sheet names.
4. An operator or separator at the end
A formula that ends with +, -, &, a comma or an opening bracket is incomplete. This often happens when a formula is cut off while copying.
5. Excel-only syntax
Some formulas from Excel tutorials use syntax that Google Sheets doesn’t understand. Our test of =@A1 returned a parse error: remove the @. Excel table references such as Table1[@Price] are also Excel syntax; replace them with normal ranges such as C2:C.
6. A space or typo inside a function name
=SU M(A1:A3) is a parse error. A function name that is spelled wrong but has no space, such as =SUMM(A1:A3), gives a different error: #NAME?, with the message Unknown function: ‘SUMM’.
7. Commas or semicolons: the locale problem
This is the most common cause for anyone outside the United States and the United Kingdom. Spreadsheets whose locale uses a comma as the decimal separator (Spain, Germany, France, Brazil and many others) separate arguments with semicolons. A formula copied from an English-language site, written with commas, fails there.
Found in testing: in a spreadsheet set to Spain, most comma formulas returned Formula parse error, but not all. =SUM(1,2) returned 1,2 instead of 3, and =SUMPRODUCT({1,2;3,4}) returned 4,6 instead of 10, because the commas were read as decimal marks. No error appears, so check the result as well as the error.
Converting a formula is more than swapping commas for semicolons:
| Element | United States style | Spain style |
|---|---|---|
| Between arguments | =IF(A1>0, 1, 0) |
=IF(A1>0; 1; 0) |
| Decimal numbers | 1.5 |
1,5 |
| Columns in an array | {1, 2} |
{1\2} |
| Rows in an array | {1; 2} |
{1; 2} |
Commas inside text in quotes never change. The formula checker applies all of these rules for you; we checked its conversions in a Spanish-locale spreadsheet and all of them returned the expected results. To see which style your spreadsheet uses, open File → Settings and look at the locale.
Not a parse error: #NAME?
If you see #NAME? instead, the syntax is fine but Google Sheets doesn’t recognize a name. The usual cause is text without quotes: =IF(A1=1, yes, no) returned #NAME? with the message Unknown range name: ‘YES’. Put text in quotes: =IF(A1=1, "yes", "no"). Another cause is a formula copied from an Excel tutorial: in our tests TEXTBEFORE, TEXTAFTER and TEXTSPLIT gave Unknown function, and we show the Google Sheets alternatives in extracting text before or after a character.
IMPORTRANGE and parse errors
IMPORTRANGE needs both arguments in quotes: the spreadsheet URL or ID, and the range as text, for example =IMPORTRANGE("spreadsheet_url", "Sheet1!A1:C10"). When we left out the quotes around the range, the formula didn’t fail with a parse error but with #REF! and Unresolved sheet name, because Sheets looked for that tab in the current file. See #REF! error: every cause for the access-related errors of IMPORTRANGE, and IMPORTRANGE not working for the full list.