If an Excel formula fails in Google Sheets, check separator syntax, range shape, and function support first. Those three faults usually lead to #ERROR!, #N/A, or a result that looks valid but is wrong. Start with formula display, then the calculation setting, then the data and references.
Quick triage table
Use this table to match the symptom to the narrowest fix. Start with the symptom you actually see in the cell, not the formula you expected to work.
| Symptom | Likely cause | Exact check | Sheets-compatible fix | Applies to |
|---|---|---|---|---|
| Formula appears as plain text | Show formulas is enabled, or the cell is formatted as plain text | Check View > Show formulae, or press Ctrl + ` | Turn off Show formulae; change format to Automatic or Number, then re-enter the formula | Pasted Excel formulas |
| #ERROR! right after paste | Syntax mismatch | Look for missing equal sign, wrong commas, or unmatched parentheses | Rewrite with Sheets syntax: =, correct commas, balanced parentheses, and valid function spelling | Pasted Excel formulas, SUM, LOOKUP |
| Formula returns the wrong total | Text-formatted numbers in the range | Select the range and check whether numbers align left | Format as Number, then convert text values to numbers | SUM |
| SUM ignores some cells | Hidden spaces or non-printable characters keep values as text | Check for leading spaces, trailing spaces, or pasted data from another source | Use TRIM and CLEAN, then re-enter the values if needed | SUM, LOOKUP |
| LOOKUP returns #N/A | Lookup range is not sorted, or the match column has text-number mismatch | Compare the lookup value to the first column of the range and inspect formatting | Normalize the data type, or use a lookup pattern built for Sheets | LOOKUP |
| Imported Excel formula breaks after conversion | Structured references or table references do not carry over cleanly | Look for table-style references such as Table1[Column] | Replace the table reference with a normal range such as A2:A100 | Pasted Excel formulas, LOOKUP |
| Formula stops after rows are added | Range boundaries are fixed too tightly | Check whether the formula points to a partial range like A2:A10 | Expand the range or use ARRAYFORMULA for formulas that should fill down | Pasted Excel formulas, SUM, LOOKUP |
| Changes do not recalculate | Calculation setting is not set to update on change | Open File > Settings > Calculation and inspect the recalculation option | Set recalculation to On change | Pasted Excel formulas, SUM, LOOKUP |
| Formula never updates after input changes | Iterative calculation is interfering with normal recalc behavior | Open File > Settings > Calculation and check whether iterative calculation is enabled | Turn off iterative calculation unless the formula needs it | Pasted Excel formulas, SUM, LOOKUP |
| Excel formula returns a different result in Sheets | Unsupported Excel-only function or different function behavior | Compare the function name against Sheets support and note any Excel-only feature | Replace it with a Sheets function or rebuild the logic with helper cells | Pasted Excel formulas, LOOKUP |
| Formula references the wrong cells after copying | Absolute and relative references were translated differently than expected | Inspect the dollar signs in cell references such as A1, $A$1, and A$1 | Fix the row and column anchors, then copy again | Pasted Excel formulas, SUM, LOOKUP |
| Worksheet shows an earlier broken version after import | Conversion introduced corruption or a bad edit history step | Open File > Version history and inspect earlier saves | Restore an earlier version or make a copy and repair the copy | Pasted Excel formulas |
How do you fix a formula that shows in the cell instead of calculating?
When a formula displays as text, Sheets is usually treating the entry as plain text or showing formulas on purpose. That is different from a formula that calculates the wrong answer. Turn off formula display, then check the cell format and re-enter the formula with the leading equal sign.
- Open View > Show formulae and turn it off, or press Ctrl + `.
- Select the cell or range, then open Format > Number and choose Automatic or Number.
- Re-enter the formula so it begins with =.
- Check that the formula uses parentheses and commas in Sheets syntax.
If a cell shows =SUM(A1:A5) instead of a result after import, the problem is display mode or text formatting, not SUM itself. Fix the display first, then test the formula again before changing the range.
Is the formula written in Sheets syntax?
Google Sheets accepts the same general formula structure as Excel, but small syntax differences break pasted formulas fast. The most common failures are missing equal signs, wrong punctuation, function names typed incorrectly, and quote marks that do not enclose text properly.
- Confirm the formula starts with =.
- Check each opening parenthesis has a closing match.
- Replace semicolons or other separators with the comma pattern Sheets expects in your locale.
- Verify the function name spelling exactly.
- Wrap text arguments in quotation marks, such as "Paid".
- If the Excel version uses a syntax Sheets does not accept, rewrite the formula with native Sheets functions.
A common first-timer mistake is pasting a formula that uses the right logic but the wrong separator. A lookup written with a semicolon-separated argument list may look fine, yet Sheets reads it as invalid syntax.
Why is your formula not recalculating?
If the formula is valid but stays stale, the issue is often calculation settings rather than the formula itself. In Sheets, the recalculation option and iterative calculation can change when formulas update, and the default may not match a workbook imported from Excel.
- Open File > Settings > Calculation.
- Set the Recalculation option to On change.
- Check whether Iterative calculation is enabled.
- Turn off iterative calculation unless the formula actually depends on it.
- Save the settings, then change one input cell and watch for recalculation.
Guides from third-party Sheets troubleshooting pages commonly point to the Calculation tab, the Recalculation option, and the On change setting. They also warn that iterative calculation can keep a sheet from updating the way users expect.
Are the cells numbers or text?
SUM and many lookup formulas fail when numbers are stored as text. That can happen after CSV import, copy-paste from another sheet, or manual formatting. Hidden spaces and non-printable characters can create the same symptom, because the cell looks numeric but behaves like text.
- Select the affected range.
- Open Format > Number and choose Number or Automatic.
- If values still behave like text, use TRIM to remove leading and trailing spaces.
- Use CLEAN for non-printable characters.
- Re-enter the cleaned values, then recalculate the formula.
If SUM returns 0 for a column that looks full of amounts, check whether those amounts were pasted from another system and left-aligned. Convert the cells first; otherwise SUM may ignore them.
How do you fix broken references?
Reference problems show up when a formula points to the wrong row, wrong column, a deleted cell, or a range boundary that no longer fits the data. Imported Excel workbooks can also contain named ranges or structured references that Sheets cannot interpret as-is.
- Inspect every cell reference for the correct row and column.
- Check whether any referenced rows or columns were deleted.
- Expand range boundaries if the source data grew beyond the original range.
- Review named ranges in Data > Named ranges if the formula depends on them.
- Replace imported structured references such as table-style column names with ordinary A1 ranges.
Structured references often break during conversion because Sheets does not handle Excel table syntax the same way. If a formula points to Table1[Sales], replace it with a normal range such as C2:C or a fixed range that matches the data.
When should you use ARRAYFORMULA?
Use ARRAYFORMULA when an Excel-style fill-down pattern needs to work across a whole range in Sheets. It is especially useful for lookup formulas that should expand automatically, and for cases where copied rows in Excel need one formula to cover many cells in Sheets.
- Identify the repeated formula pattern across rows.
- Place one formula at the top of the output range.
- Wrap the calculation in ARRAYFORMULA when the logic should expand across many rows.
- Check that the output area below is empty so results can spill.
- Test one input change to confirm the range updates correctly.
Use it sparingly. If the problem is a bad reference or text data, ARRAYFORMULA will not fix that. It only helps when the Sheets version needs to calculate across a range instead of row by row.
Still not working?
If the formula still fails after syntax, formatting, references, and calculation settings are fixed, move to recovery. The next step is version rollback or a clean copy of the file, especially after a bad import or a chain of edits that changed multiple formulas at once.
- Open File > Version history.
- Restore an earlier version if the sheet worked before the failure.
- If you need a safer repair path, choose Make a copy and test changes in the copy.
- If the issue remains after restoring, replace the broken formula with a simpler Sheets-native version.
- For imported workbooks with many Excel-only formulas, rebuild the most important formulas one by one instead of pasting the whole file back in.
Keep formulas in plain Sheets syntax, avoid text-formatted input ranges, and check the Calculation setting after a workbook import.
Frequently asked questions
Does excel formula work in google sheets?
Many Excel formulas work in Google Sheets, but not all of them do, and some behave differently. If a pasted formula fails, check syntax first, then the function name, then whether the formula uses Excel-only features such as structured references or workbook-specific behavior.
Why is my sum formula not working google sheets?
SUM usually fails because the input range contains text, hidden spaces, or a broken reference. Check Format > Number, clean the cells with TRIM and CLEAN, and confirm the range still points to the intended cells. Text values often cause the wrong total.
Why formula is not working in google sheets
Start with the formula itself: equal sign, parentheses, commas, and function spelling. If those are correct, move to cell format, then to references, then to calculation settings under File > Settings > Calculation. A formula that looks valid may still fail if Sheets treats the input as text.
Why formula is not working in excel sheet
If the issue is inside Excel, the same basic checks still apply: syntax, references, data type, and calculation mode. In Excel, a manual calculation setting or a text-formatted number can stop results from updating until the workbook recalculates or the cells are reformatted.
Why does my Excel formula fail after I paste it into Google Sheets?
The usual causes are separator syntax, unsupported Excel-only functions, or imported table references that Sheets does not read the same way. Rewrite the formula in Sheets syntax, replace structured references with normal ranges, and use ARRAYFORMULA when the original logic depended on fill-down behavior.
Which Excel functions are unsupported or behave differently in Google Sheets?
Any function that depends on Excel-only features, workbook structure, or table references may need rewriting. If a formula fails after paste, check whether the function exists in Sheets and whether its arguments or output shape differ. When in doubt, rebuild the formula with a Sheets-native equivalent.
Why is my Google Sheets formula not updating or recalculating?
Open File > Settings > Calculation and set the Recalculation option to On change. Check whether iterative calculation is enabled, since that can block the update pattern you expect. After changing the setting, modify one input cell and confirm the result refreshes.
How do I fix a SUM formula that returns the wrong value in Google Sheets?
Check whether the range includes text-formatted numbers, blank-looking cells with spaces, or a boundary that misses recent rows. Set the cells to Number, clean the input with TRIM and CLEAN, then extend the range if the data grew beyond the original selection.
When should I use ARRAYFORMULA to replace an Excel-style formula in Sheets?
Use ARRAYFORMULA when one formula should cover many rows in Sheets instead of being copied down. It is a good fit for repeated calculations and some lookup patterns. It is not a fix for bad data, broken references, or an unsupported Excel-only function.