Excel Math Not Working? Fix Formula and Calculation Errors

$Excel Math Not Working? Fix Formula and Calculation Errors$

If Excel math is not working, first make sure the cell contains a formula beginning with =, then set calculation to Automatic and check that the values are numbers rather than text. On Windows, choose Formulas > Calculation Options > Automatic; if a formula is displayed instead of its answer, change the cell to General and re-enter it.

How Excel calculates formulas

Excel evaluates formulas using cell values, operators, functions, and references. A formula normally recalculates when a value it depends on changes, but the result you see can be affected by calculation settings, the stored type of a value, or the cell’s number format. That is why a cell that looks like a simple arithmetic problem can fail in several different ways.

For example, with a quantity in A2 and a unit price in B2, enter =A2*B2 in C2. If A2 contains 4 and B2 contains 12.50, C2 should show 50. If it does not, inspect the formula bar and the underlying contents of A2 and B2 rather than assuming the multiplication operator is the problem.

Excel also follows standard operator precedence: multiplication and division are evaluated before addition and subtraction, unless parentheses change the order. With values in A2, B2, and C2, =A2+B2*C2 multiplies B2 by C2 before adding A2. To add A2 and B2 first, use =(A2+B2)*C2. A result that looks surprising may therefore be a valid calculation with an unintended order of operations.

Check calculation mode first

In Automatic calculation mode, Excel recalculates dependent formulas when their inputs change. If the workbook is set to Manual, formulas can keep showing old results until you request a calculation. This mode may be useful in a very large workbook, but it is a common reason numbers appear frozen.

Open the Formulas tab and select Calculation Options.
Choose Automatic.
Change an input cell and see whether dependent results update.

For a one-time refresh in Windows desktop Excel, press F9 to calculate open workbooks. Press Shift+F9 to calculate the active worksheet, or Ctrl+Alt+F9 to force a full calculation of all formulas. These commands recalculate; they do not repair a bad formula or convert text into numbers. On Excel for Mac, use Formulas > Calculate Now or Formulas > Calculate Sheet if the corresponding command is available; keyboard shortcuts can differ by keyboard and macOS configuration.

Calculation mode can be associated with workbooks open in the same Excel session, so check it when a newly opened file also seems to calculate manually. If a workbook is deliberately designed for manual calculation, switching it to Automatic can make a large model slower. In that case, calculate when needed and confirm that the final results are current before sharing or exporting the file.

When a formula appears as text

If a cell shows the characters of a formula instead of its result, check whether Show Formulas is turned on. In Windows, press Ctrl+` (the grave-accent key, usually above Tab) to toggle formula display, or select Formulas > Show Formulas. On Mac, use Formulas > Show Formulas because the keyboard shortcut can depend on the keyboard layout.

If only one cell is affected, its format may be Text. Select the cell, choose Home > Number Format > General, then press F2 and Enter to make Excel parse the contents again. Merely changing a cell from Text to General does not necessarily convert an existing formula; re-entering it does. Also look for an apostrophe typed before the equals sign, or a leading space. Either can make the entry behave as text.

When many formulas have been pasted in as text, select the affected range, change the number format to General, and use Data > Text to Columns, then finish the wizard without changing the delimiter settings. This can prompt Excel to interpret the entries again, but inspect a small sample first, especially if the cells contain dates or values separated by punctuation.

Numbers stored as text

A value can look numeric and still be text. Common causes include importing data from a website or CSV file, leading apostrophes, spaces, and separators that do not match the computer’s regional settings. Text numbers may align differently from numbers by default, but alignment is only a clue; formatting can override it.

With amounts in A2:A4, a total in A5 entered as =SUM(A2:A4) adds numeric cells. If A2 is the text value 10, A3 is numeric 20, and A4 is numeric 30, the result is 50 because SUM ignores text in referenced cells. That can make a total look plausible while silently excluding an entry.

To investigate, select a suspicious cell and look in the formula bar. Try the warning icon that may appear beside a number stored as text and choose Convert to Number. Other options include removing unwanted spaces or using Data > Text to Columns to convert a clean imported column. Avoid applying a blanket conversion to mixed data without checking it: identifiers such as postal codes may intentionally be text, and converting them can remove leading zeros.

Regional settings matter for decimal and thousands separators, and for the characters Excel expects in imported data. Excel’s formula argument separator may also appear as a semicolon rather than a comma under some regional configurations. The examples here use comma separators; if Excel rejects a formula copied from elsewhere, check its local separator conventions instead of assuming the function is unavailable.

Inspect references, operators, and errors

When a formula returns an error, the error value usually points toward the type of problem. #DIV/0! means a formula is dividing by zero or by a blank cell treated as zero. #VALUE! commonly indicates an inappropriate value type, such as text where arithmetic is expected. #REF! means a reference is invalid, often because a referenced row, column, or cell was deleted. #NAME? can indicate a misspelled function name or unrecognized text in a formula.

For example, with revenue in B2 and units in C2, enter =B2/C2 in D2 to calculate revenue per unit. If C2 is blank or zero, Excel cannot divide by it and returns #DIV/0!. Decide what should happen in that case before changing the formula: perhaps the input should be corrected, or perhaps the output should remain blank until units are entered.

Check parentheses, cell references, and signs carefully. A minus sign in place of a multiplication symbol, an omitted closing parenthesis, or a reference shifted one row can produce a valid but incorrect result. Click the formula cell and review the colored reference outlines, or use Formulas > Evaluate Formula to follow how Excel evaluates the expression step by step.

Formatting can hide a correct result

Sometimes the calculation is right but the display is misleading. A number format may round a value to fewer decimal places, show a date instead of a number, or display a currency symbol. Select the cell and inspect Home > Number Format; temporarily choosing General can help reveal the stored result. Increasing decimal places can also distinguish a rounded display from a genuinely different calculation.

Excel stores dates as serial numbers and displays them according to the selected date format. If arithmetic unexpectedly produces a calendar date, the result cell may be formatted as Date. Change its format to General or Number to view the underlying numeric value. Conversely, formatting a number as a date does not turn the value into a meaningful date calculation.

Excel’s displayed precision is not unlimited: it stores numbers to 15 significant digits. A long account number or identifier should generally be stored as text, not treated as a quantity for arithmetic. For ordinary calculations, also remember that decimal fractions such as 0.1 cannot always be represented exactly in binary; a tiny displayed difference can arise in some calculations. Use suitable number formatting for presentation, and do not round intermediate values unless the calculation rules require it.

Find circular references and workbook-specific issues

A circular reference occurs when a formula depends on its own result, directly or through a chain of other formulas. For instance, putting a total formula in a cell that the same total range includes creates a loop. Excel may display a circular-reference warning or leave a result that does not behave as expected. Look under Formulas > Error Checking > Circular References to locate listed cells, then correct the range or move the total outside it.

Excel supports intentional circular calculations through iterative calculation settings, but enabling iteration is not a general fix for ordinary formula errors. It can make results depend on iteration limits and starting values. Only use it when the workbook’s model specifically requires circular calculations and its instructions explain the expected behavior.

If one workbook misbehaves while a simple new workbook calculates correctly, look for workbook-specific causes: manual calculation mode, broken external links, deleted references, or formulas that rely on functions unavailable in an older Excel edition. Microsoft 365 includes newer functions, but a workbook opened in an older version may show #NAME? for an unsupported function. Check the workbook’s source and Excel version before replacing a formula with a different approach.

A reliable troubleshooting sequence

Work from simple checks to more disruptive changes. A consistent order helps distinguish a calculation setting from a data problem and reduces the risk of changing a workbook that was behaving correctly.

Click the result cell and confirm that the formula bar shows the intended formula, references, and operators.
Set calculation to Automatic, then recalculate if the result still looks stale.
Check whether the cell or its inputs are formatted as Text, and convert genuine numeric text carefully.
Inspect the error value, blank inputs, zero divisors, and any deleted or shifted references.
Temporarily use General format and show more decimal places to rule out a display issue.
Check for circular references and confirm the workbook is open in a version that supports its functions.

For a useful test, reduce a complicated calculation to a small example in a spare area or a copy of the workbook. Enter known values and compare the expected arithmetic with the result. If the simple case works, the issue is more likely in the original data, references, or workbook settings than in Excel’s basic arithmetic.

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. Toggle Formulas > Show Formulas off; if only one cell is affected, change its format to General and re-enter the formula.

Why is my Excel total wrong even though the numbers look right?
One or more entries may be numbers stored as text, which SUM can ignore when they are referenced in a range. Check the source cells and convert genuine numeric text, while leaving codes and identifiers as text when appropriate.

Why does Excel not update when I change a cell?
The workbook may use Manual calculation. Choose Formulas > Calculation Options > Automatic, then recalculate. Also check whether the formula actually references the cell you changed.

Why does Excel show 0 when I add cells?
Check that the formula references the intended range and that the inputs are numeric. A text-formatted number may be ignored by SUM, and a custom number format can also hide or disguise a displayed value.

Why do I get #VALUE! in an arithmetic formula?
Look for text, spaces, or other nonnumeric content in a cell the formula uses. Imported values can look like numbers while remaining text; convert or clean only the values that are meant to be numeric.

Can I fix a wrong calculation by pressing F9?
F9 recalculates formulas, but it does not correct their logic, repair references, or convert text values. Use it when a result is stale; if the result remains wrong, inspect the formula and its inputs.

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.