How to Fix "Formula parse error" (#ERROR!) in Google Sheets

By Gerard Fernandez · Updated · 4 min read

When a cell shows #ERROR! and the tooltip says Formula parse error, Google Sheets couldn't even read your formula. It's a typing problem, not a data problem. To find out which typos really cause it today, we typed nine broken formulas into a real sheet. Some gave #ERROR!, some gave a different error, and two were quietly fixed by Sheets itself.

Google Sheets test table: each typed formula in column C and its result in column D, such as #ERROR! for curly quotes, #NAME? for text without quotes and 230 for a missing bracket
Our test: the formula as typed (column C) and what Sheets did with it (column D).

What gives a parse error (tested)

TypedResult in our testFix
=IF(A2>100,“High”,“Low”)#ERROR!Straight quotes: "High"
=IF(A2>100,"High,"Low")#ERROR!Close every quote: "High","Low"
=Budget 2026!A1#ERROR!='Budget 2026'!A1
=A2*/2#ERROR!One operator: =A2/2
=1,000+5#ERROR!=1000+5
=SUM(A2:A3))Not accepted: "missing one or more open parentheses"Remove the extra )
=IF(A2>100,High,Low)#NAME? "Unknown range name: 'HIGH'"Quotes around text
=SUM((A2:A3)Worked (230): Sheets added the missing )Nothing to fix
=IF(A2>100;"High";"Low")Worked: Sheets changed ; to ,Nothing to fix

1. Curly quotes

Google Sheets cell with =IF(A2>100,“High”,“Low”) in the formula bar showing #ERROR! and the tooltip Formula parse error.
Typographic quotes “ ” look almost the same, but Sheets can't read them.

It's the hardest cause to spot, because the formula looks perfectly normal. Formulas copied from Word, Google Docs, a chat or some websites often come with typographic quotes “ ” instead of straight ones " ".

Fix: click the cell, delete each quote in the formula bar and type it again from your keyboard. If there are many, use Find and replace with Also search within formulas ticked: replace “ with ", then ” with ".

2. A quote that isn't closed

In =IF(A2>100,"High,"Low") the quote after High is missing, so Sheets reads High, as the text and then finds Low"), which makes no sense. Result: #ERROR!.

Fix: every piece of text needs an opening and a closing ". Count them: the total should be an even number.

3. Sheet names with spaces

When you refer to another tab whose name contains spaces, the name must be in single quotes:

='Budget 2026'!A1

Without them, =Budget 2026!A1 gave #ERROR! in our test. The easiest way to get it right is not to type it: start the formula, click the other tab and select the cells. Sheets writes the reference, quotes included. If the quotes are right but the tab doesn't exist, you get a different error: "Unresolved sheet name".

4. Doubled or missing operators

Between two values there must be exactly one operator: + - * / ^ &. =A2*/2 has two in a row and gave #ERROR!.

  • Remove the extra one: =A2/2.
  • Don't leave them out either: =2(A2+A3) needs a *, as in =2*(A2+A3).
  • To join text, use &: =A2&" "&B2. See how to combine text.

5. Numbers with thousands separators

Inside a formula, type numbers without thousands separators or currency symbols. =1,000+5 gave #ERROR!; =1000+5 works. Format the result as you like afterwards with Format → Number.

Brackets: one extra vs one missing

Google Sheets dialog: There was a problem. It looks like your formula is missing one or more open parentheses. If you don't want to enter a formula, begin your text with an apostrophe (').
An extra closing bracket isn't even accepted.

Brackets behaved differently from what most guides say:

  • One ) too many (=SUM(A2:A3))): Sheets didn't accept the formula at all and showed "It looks like your formula is missing one or more open parentheses. If you don't want to enter a formula, begin your text with an apostrophe (')." Click OK, then delete the extra bracket.
  • One ) missing at the end (=SUM((A2:A3)): Sheets added it for you and the formula returned 230. Check the result anyway: in nested formulas, a bracket added at the end may not be where you meant it.

With nested IFs, writing the formula on several lines helps: press Ctrl+Enter inside the formula bar to add a line break, so each IF sits on its own line.

Text without quotes gives #NAME? instead

=IF(A2>100,High,Low) didn't give a parse error. It gave #NAME? with "Unknown range name: 'HIGH'.": without quotes, Sheets thinks High is the name of a range. The fix is the same, quotes around the text: "High". More in how to fix #NAME?.

Commas or semicolons?

Google Sheets separates arguments with commas in some locales (United States, United Kingdom…) and semicolons in others (Spain, Germany, France, Brazil…). In our test, a sheet with the US locale converted the semicolons to commas automatically: =IF(A2>100;"High";"Low") was saved as =IF(A2>100,"High","Low") and worked.

If a copied formula still fails in your file, check the locale in File → Settings → Locale and use the separator it expects. In semicolon locales, columns inside { } arrays are separated with a backslash: {1 \ 2 \ 3}.

Frequently asked questions

What's the difference between #ERROR! and the other errors?

#ERROR! means Sheets couldn't read the formula at all. The others mean it read the formula but something went wrong when calculating: #NAME? for an unknown name, #VALUE! for the wrong type of data, #N/A for a lookup that found nothing, and #REF! for a broken reference.

Can IFERROR hide a parse error?

No. A formula that can't be read never runs, so IFERROR never gets a chance to catch anything. You have to fix the formula itself.

The formula works in Excel or in another file. Why not here?

Check the locale of both files in File → Settings → Locale: one may use commas and the other semicolons. Also look for curly quotes, which often come with formulas copied from documents or websites.

Why does my IMPORTRANGE give #ERROR!?

Both arguments must be text in double quotes: the file URL and the range, for example "Sheet1!A1:C10". See how to use IMPORTRANGE.