Fixes / Excel · Checked September 30, 2026

Excel There's a problem with this formula: meaning and fixes

Short answer

Excel shows this when it cannot read what you typed as a valid formula. Most often the entry starts with =, -, or + but is not meant to be a formula (like "-note" or "+372 phone"), or a formula has a missing bracket or the wrong separator. Press Esc, then type an apostrophe (') before the text, or correct the formula syntax.

What this message means

Excel treats anything that starts with an equals sign (=), minus (-), plus (+) or @ as a formula and tries to parse it before accepting the entry. If the text doesn't follow formula grammar, Excel stops, shows this message and won't let you leave the cell until you fix or cancel it. The message doesn't mean your workbook is damaged. It is a syntax check, like a spell check that won't let you continue. It can also appear when a Find and Replace, pasted formula, data validation rule or conditional formatting rule would produce an invalid formula, and when a VLOOKUP or other formula points to another workbook with a badly written reference.

Common causes

Cause	How to tell
Text that starts with =, -, + or @ but isn't a formula	You typed something like "-- see notes", "=== Total ===", "+1 555 0100" or "-5 kg" and the dialog appears when you press Enter. The dialog text also says "Not trying to type a formula?"
Wrong list separator for your region (comma vs semicolon)	A formula copied from a website or colleague, such as =IF(A1>0,"Yes","No"), fails every time, but it works when you replace the commas with semicolons. Common on PCs set to European regions where the decimal separator is a comma.
Missing or extra parentheses	The formula has several nested functions (IF, AND, VLOOKUP). When you count opening ( and closing ) brackets they don't match, or a function name like IF is followed directly by a comma or space instead of "(".
Curly (smart) quotes or missing quotes around text	The formula was pasted from Word, email, a PDF or a web page and the quotes look slanted (“ ”) instead of straight ("). Or a text value like Yes appears in the formula without any quotes.
Bad reference to another sheet or workbook	The formula points to another sheet whose name contains a space or symbol but isn't wrapped in single quotes, or to another file without the [Workbook.xlsx] square brackets. Typical with VLOOKUP or XLOOKUP across files.
Find and Replace would create an invalid formula	The dialog appears during Replace All rather than while typing. The replacement text produces a formula that references a table column, sheet or name that doesn't exist.

How to fix it

1. Enter it as text with a leading apostrophe

Press Esc to cancel the entry that Excel rejected.
Select the cell again and type an apostrophe (') first, then your text, for example '-- see notes or '+1 555 0100.
Press Enter. The apostrophe is hidden in the cell and only shows in the formula bar.
For many cells at once, select them, go to Home > Number Format and choose Text before typing. Existing entries won't change, so retype them.

2. Use the list separator your Excel expects

Separator setting steps are for Windows 10 and 11. Excel for Mac takes the separator from macOS region settings (System Settings > General > Language & Region), and uses semicolons when the decimal separator is a comma.

Look at a built-in function hint: start typing =IF( in an empty cell and read the tooltip. If it shows IF(logical_test; [value_if_true]; ...) your Excel uses semicolons.
Replace the commas between arguments in your formula with semicolons (or the other way round) and press Enter.
To change the separator itself on Windows 11: press Windows key + I, go to Time & language > Language & region > Administrative language settings, then Formats tab > Additional settings > Numbers tab, and edit List separator. Click OK twice.
On Windows 10: Settings > Time & Language > Region > Additional date, time, & regional settings > Change date, time, or number formats > Formats tab > Additional settings > Numbers tab > List separator.
Restart Excel after changing it.

3. Balance the parentheses

Click in the formula bar. Excel colours each matching pair of brackets, so an unmatched one stands out.
Make sure every function name is followed directly by an opening bracket, for example IF( not IF, or IF (.
Count opening and closing brackets. They must be equal. Example of the correct form: =IF(AND(M12<>TODAY(),V12<>"X"),"NO","RE").
Press Enter to test. If Excel offers to correct it, check its suggestion before accepting.

4. Fix quotes and number formats inside the formula

Delete every pasted quote mark and retype it with the keyboard so it is a straight " character.
Put all text values in double quotes, for example =IF(A1="Paid",1,0).
Remove currency symbols and thousands separators from numbers typed inside a formula. Write 1000, not $1,000, because $ means an absolute reference and the comma separates arguments.
Press Enter to test.

5. Correct references to other sheets and workbooks

Wrap sheet names that contain spaces or symbols in single quotes: ='Sales 2026'!A1.
For another workbook, put the file name in square brackets: =[Q2 Operations.xlsx]Sales!A1:A8. If the sheet name has spaces, quote both: ='[Q2 Operations.xlsx]Sales Data'!A1.
The easiest way to get this right is to open both workbooks, start the formula, then click the cell or range in the other file so Excel writes the reference for you.
In VLOOKUP, check that the lookup range reference is complete and the arguments are separated by the correct separator.

6. Fix a Find and Replace or rule that breaks formulas

Cancel the dialog and check the Replace with text. Run Find All first to see which cells would change.
Make sure the new sheet name, table name or column name actually exists. Replacing a table name with one that lacks the same column makes the formula invalid.
If the message comes from Data > Data Validation or Home > Conditional Formatting > Manage Rules, open the rule and fix the formula there using the same checks (brackets, separators, quotes).
To replace text that begins with = in cells that are not formulas, first format them as Text or add a leading apostrophe.

Next time, skip the search

Crade is an AI assistant for Mac and Windows that sees your screen. When a message like this pops up, ask “what does this mean?” and it explains the exact error in front of you, step by step.

Download Crade

Still not fixed?

Press Esc to leave the cell without saving the entry, then rebuild the formula piece by piece in an empty cell, starting with the innermost function, and press Enter after each part to find which piece fails. On Windows, Formulas > Evaluate Formula steps through a working formula so you can check its logic once it enters. You can also use the Insert Function (fx) button next to the formula bar, which fills in arguments with the correct separators for you. If a formula from a shared or older file still fails, post the exact formula text and your Excel version (File > Account) in the Microsoft Tech Community Excel forum, or ask your IT team whether your regional settings are managed by policy.

Questions people ask

How do I type a minus sign or equals sign at the start of a cell without Excel treating it as a formula?

Type an apostrophe first, for example '-note or '=== Header ===. The apostrophe tells Excel the entry is text and doesn't appear in the cell.

Why does a formula from the internet work for others but not for me?

Your Excel probably uses semicolons as the argument separator because of your region settings. Replace the commas between arguments with semicolons, or change the list separator in Windows region settings.

Why can't I click out of the cell after this message appears?

Excel won't accept an invalid formula into a cell. Press Esc to cancel the entry, or fix the formula and press Enter.

Why do I get this error with VLOOKUP to another file?

The reference to the other workbook is usually malformed, such as a missing [ ] around the file name or missing single quotes around a sheet name with spaces. Open both files and click the range in the other workbook so Excel writes the reference correctly.

Is this the same as #NAME? or #VALUE! errors?

No. This message blocks the entry before it is saved because the syntax is invalid. #NAME? and #VALUE! appear in the cell after a formula has been accepted but can't calculate.

Sources

Related errors