Excel Math Formula Not Working? Causes and Fixes Guide

Errors & fixes · Updated November 19, 2026

If an Excel math formula is not working, first check that the cell contains a formula beginning with =, the inputs are numeric, and the workbook is set to calculate automatically. Then check for text formatting, incorrect cell references, missing parentheses, or an error value; these are common reasons a formula shows as text, returns an unexpected result, or does not update.

Start with these quick checks

Before rebuilding a formula, identify what Excel is actually showing. A formula that appears literally in the cell needs a different fix from a formula that calculates but returns the wrong number. Check the formula bar and the cell’s display, then try these basic steps:

  • Select the cell and look in the formula bar to confirm the expression begins with = and refers to the cells you intended.
  • Check whether the result cell is formatted as Text or whether Show Formulas is turned on.
  • Confirm that the referenced cells contain numbers, not numbers stored as text or entries with unexpected spaces.
  • Look at Formulas > Calculation Options and select Automatic if the workbook should update as inputs change.
  • Inspect the result for an error such as #VALUE! or #REF!; the error often points to the cause.

Make a copy before making broad changes, especially when the workbook has many formulas or imported data. Formatting or converting entire columns can affect dates, identifiers, and other values that should remain text.

How Excel evaluates a math formula

Excel reads a formula as an instruction. The equals sign marks the cell contents as a calculation, operators such as +, -, *, and / specify arithmetic, and cell references tell Excel which values to use. A formula can therefore be syntactically valid but still produce an unexpected answer if its references or inputs are wrong.

For example, with 12 in A2 and 8 in B2, the formula =A2+B2 returns 20. With values 12, 8, and 3 in A2:A4, the formula =SUM(A2:A4) returns 23. The first adds two referenced cells; the second uses a function to add a range. These formulas are valid in current Excel for Microsoft 365 on Windows.

Excel also follows operator precedence: multiplication and division are evaluated before addition and subtraction, unless parentheses change the order. With 10 in A2, 5 in B2, and 2 in C2, =A2+B2*C2 returns 20 because 5 times 2 is calculated first. With the same cell values, =(A2+B2)*C2 returns 30. When the result seems mathematically wrong, check the intended order of operations rather than assuming Excel has miscalculated.

When Excel displays the formula instead of its answer

If a cell shows something like =A2+B2 rather than the sum, there are three common explanations. First, Show Formulas may be enabled. On Windows, use Formulas > Show Formulas to turn it off. You can also check the formula bar to distinguish a displayed formula from a calculated result. On Mac, the Show Formulas command is also on the Formulas tab, though ribbon layout can vary by Excel release.

Second, the cell may be formatted as Text. Select the cell, choose Home > Number Format > General, and then re-enter the formula so Excel interprets it. Changing the format alone may not convert a formula that was already entered as text. You can edit the cell and confirm the entry, or clear and type the formula again.

Third, the entry may have a leading apostrophe or an extra character before the equals sign. Excel treats an apostrophe at the beginning of a cell entry as a signal to store the following content as text. Remove it if the cell is meant to calculate. A narrow column can hide part of a result, but it does not normally turn a formula into visible formula text; widen the column if the actual issue is that the number is obscured.

Numbers stored as text and other input problems

A cell can look like a number but be stored as text. This often happens after copying data from a website, importing a text or CSV file, or entering a value with a leading apostrophe or spaces. Arithmetic may then return #VALUE!, ignore an entry in some calculations, or produce a result that does not match the visible values. A green error indicator may offer a Convert to Number option, but review the data before applying it to a large range.

To investigate, select an input cell and check its alignment, number format, and formula bar. Alignment is only a clue, not proof, because formatting can override Excel’s usual display. If the values are consistently meant to be numbers, select the affected cells and use the warning menu’s Convert to Number command when available. For data that contains extra spaces or inconsistent characters, clean the source first or use a deliberate conversion method rather than blindly changing a whole column.

For instance, with the text value 15 in A2, =VALUE(A2) converts text that Excel recognizes as a number into the numeric value 15. The conversion may not work as expected if the text includes unrecognized characters or uses decimal and thousands separators that conflict with the computer’s regional settings. Also preserve values such as postal codes or product IDs as text when leading zeros or non-arithmetic meaning matters.

Cell references, parentheses, and copying formulas

A correct formula can still give the wrong answer if it points at the wrong cells. Click the result cell and inspect the colored reference outlines or the formula bar. Check for a shifted row, a wrong column, or a reference to a blank cell. If you copied a formula down a column, Excel usually adjusts relative references automatically; that is helpful for row-by-row calculations but can be a problem when one input must stay fixed.

Dollar signs make a reference absolute or partly absolute. For example, with a quantity in A2 and a fixed rate in B1, the formula =A2*$B$1 keeps B1 fixed when copied to other rows while A2 changes to A3, A4, and so on. If A2 contains 3 and B1 contains 4, the result is 12. In the formula bar, select a reference and press F4 on Windows to cycle through reference styles; on Mac, the shortcut can depend on keyboard settings, so editing the dollar signs directly is a reliable alternative.

Parentheses matter when a formula combines multiple operations. If a percentage should apply to a subtotal, put the subtotal calculation in parentheses before multiplying. Avoid inserting spaces or punctuation that changes the expression, and check that every opening parenthesis has a matching closing parenthesis. Excel often flags a malformed formula when you confirm it, but it cannot know which mathematical interpretation you intended.

Check calculation settings and refresh results

When the formula is correct but its displayed result stays old after an input changes, the workbook may be using manual calculation. In Excel for Microsoft 365 on Windows, select Formulas > Calculation Options > Automatic. Calculation mode can affect other open workbooks in the same Excel session, so check the setting if several files appear not to update. Excel for Mac has calculation settings on its Formulas tab as well; the exact ribbon arrangement can differ.

Automatic calculation updates formulas when their inputs change. Manual calculation can be useful in very large workbooks where frequent recalculation takes time, but it means results may remain stale until a recalculation is requested. On Windows, F9 recalculates open workbooks and Shift+F9 recalculates the active worksheet. Laptop function-key behavior can depend on the keyboard’s Fn setting. On Mac, use Formulas > Calculate Now or the recalculation commands shown on the Formulas tab if the keyboard shortcut differs.

Calculation delay is not the same as a broken formula. If a workbook is processing many formulas, wait briefly and check whether Excel indicates that it is calculating. If only one result is stale, confirm that the cell actually references the input that changed and that it is not a fixed value pasted over a formula.

Use error messages to narrow down the cause

Error values are clues, not generic signs that Excel has stopped working. Read the exact error and inspect the relevant inputs and references:

  • #VALUE! commonly means an operation received an unsuitable value, such as text where arithmetic needs a number.
  • #REF! means a formula contains an invalid reference, often after a referenced row, column, or cell was deleted.
  • #DIV/0! means the calculation divides by zero or by a blank cell treated as zero.
  • #NAME? can indicate a misspelled function or name, or text in a formula that Excel does not recognize as a defined name.
  • #NUM! indicates a numeric problem, such as a value outside the range a calculation can handle.

Fix the underlying issue before hiding an error. For example, with a numerator in A2 and a denominator in B2, =IFERROR(A2/B2,0) displays 0 if the division returns an error. If A2 is 12 and B2 is 0, the displayed result is 0, but that does not mean the true answer is zero; it may be more useful to show a message or correct the missing denominator. Error-handling formulas can make reports easier to read, but they should not conceal data problems that need attention.

Regional settings and formula separators

Excel’s list separator can depend on regional settings. Many installations use commas between function arguments, while some use semicolons. If Excel rejects a formula that appears correctly written elsewhere, check the separator used by your installation rather than changing the calculation itself. The decimal symbol can also vary; a value such as 1,5 may be interpreted differently from 1.5 depending on settings.

When sharing a workbook, Excel generally handles formulas within the workbook, but copied formula text from a webpage or another application may need adjustment. Use the separator Excel accepts in your environment, and avoid treating a rejected formula as evidence that its mathematical logic is wrong. Windows regional formats are managed through Windows settings; Excel for Mac follows settings that may be influenced by macOS language and region choices.

A practical troubleshooting sequence

Work from the visible symptom toward the source instead of changing several settings at once. This makes it easier to tell which change fixed the issue and reduces the chance of damaging correct data.

  1. Classify the symptom: formula text displayed, wrong number, unchanged result, or error message.
  2. Inspect the formula bar and verify the leading equals sign, operators, parentheses, and cell addresses.
  3. Check the referenced inputs for text, blanks, spaces, or unexpected characters.
  4. Confirm the result cell is not formatted as Text and Show Formulas is off.
  5. Check Formulas > Calculation Options if the result is stale.
  6. Test a small, clear example in unused cells, then compare it with the original calculation.

If only one workbook is affected, investigate its formulas, calculation mode, and imported data. If every workbook has the same problem, check Excel settings, regional separators, or whether the issue is actually a keyboard or display behavior. For a shared workbook, ask whether another person changed formulas, pasted values, or saved with manual calculation enabled.

Frequently Asked Questions

Why does Excel show the formula instead of the answer?
Show Formulas may be enabled, or the cell may be formatted as Text or have a leading apostrophe. Turn off Formulas > Show Formulas, set the cell to General, and re-enter the formula.

Why is my Excel formula not updating?
Check Formulas > Calculation Options > Automatic. In manual mode, recalculate the workbook or active sheet, and make sure the formula refers to the cell that changed.

Why does Excel say there is a problem with this formula?
Check for unmatched parentheses, a missing operator, an incorrect function name, or the wrong argument separator for your regional settings. Also confirm that the expression begins with an equals sign.

Why does adding numbers return #VALUE!?
At least one referenced value may be text, contain extra characters, or be incompatible with the operation. Check the source cells and convert only values that are genuinely intended to be numbers.

Why does my formula work in one row but not after I copy it?
Relative references change as a formula is copied. Check whether an important reference should be fixed with dollar signs, and verify that the copied formula points to the intended row and column.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.