If an Excel formula is not working, first identify the symptom: the cell shows formula text, the result stays unchanged, an error appears, or a number is wrong. Then check that specific cause. This Excel formula help guide gives you a short diagnostic order and a separate test worksheet, so you can fix the problem without replacing a useful formula blindly.

Start in a copy when the workbook is used for reporting or shared work. The menu paths below use Excel for Windows. Formula logic also applies elsewhere, but calculation and auditing controls differ on Mac and the web.
Excel formula help: choose your symptom
| Symptom | First check | Why it helps |
|---|---|---|
| Formula text is visible | Leading =, Show Formulas, then Text format | Separate display mode from an entry stored as text. |
| An old number remains | Calculation mode, then the referenced input cells | A correct formula can still show an old calculated value. |
An error such as #DIV/0! | Read the error and inspect the relevant input | Fix the cause before hiding the error. |
| A plausible but wrong number | Range, data types, copied references and parentheses | Successful calculation does not prove the intended calculation. |
1. Fix a formula that is displayed as text
- Select the affected cell and look at the Formula Bar. A calculation should begin with
=. Remove an accidental apostrophe before the equal sign when the cell is meant to calculate. - If many formula cells show expressions, check Formulas > Show Formulas. Switch it off to view results.
- If only one formula remains text, change that cell’s format from Text to General. Edit the formula again and press Enter. On Windows, F2 followed by Enter re-enters it.
Changing the number format alone does not necessarily re-enter an expression that was stored as text. Microsoft covers these separate cases in its broken-formula guide.
2. Fix a formula result that does not update
In Windows desktop Excel, check File > Options > Formulas > Workbook Calculation. Choose Automatic when that is appropriate for your workbook. Calculation settings in desktop Excel can affect other open workbooks, so note the setting before changing it.
In Excel for the web, look under Formulas > Calculation Options; its setting applies to the current workbook. If you intentionally use manual calculation, use the available calculate command rather than assuming a change in an input has already recalculated every result. See Microsoft’s calculation-setting reference.
If the result still looks unchanged, inspect the formula’s exact references. Editing B3 will not affect a formula that reads only B2. Check whether the result cell still contains a formula or was replaced with a pasted value.
3. Read the error before changing the formula
| Displayed error | Inspect | Useful repair |
|---|---|---|
#DIV/0! | A denominator that is zero or empty | Supply a valid denominator; decide explicitly how a zero case should be reported. |
#NAME? | Function spelling and defined names | Correct the name and confirm the function exists in your edition. |
#REF! | Deleted or invalid cell references | Restore the intended reference using your workbook layout or a known-good copy. |
#VALUE! | Unexpected text or incompatible inputs | Inspect the input cells; clean or convert values only when they are meant to be numbers. |
#N/A | A lookup value without a match | Check whether a matching item exists and whether the lookup range is correct. |
Do not automatically turn every error into zero. That can make a failed lookup or a missing input look like a legitimate result. Microsoft’s error reference explains the individual error types.
If the calculation came from Copilot, check the actual formula and source table rather than the assistant’s explanation alone. The Copilot analysis guide shows how to inspect editable PivotTable, chart, and formula outputs.
4. Diagnose a numeric answer that is wrong
Inspect one row before changing an entire column. Read the formula in the Formula Bar, compare its range with the inputs, and check the fixed references after copying. Parentheses can also change the answer: =5+2*3 gives 11, while =(5+2)*3 gives 21.
Imported values may look numeric while being stored as text. If Excel offers a Convert to Number warning, use it only on values that should be numeric. A product code such as 00127 may need to remain text. For a check in a spare column, =ISTEXT(A2) identifies text, and =VALUE(A2) can convert recognizable numeric text; inspect the converted output before replacing the source.
A function that ignores text may make an error disappear while silently omitting an intended amount. Confirm the source data rather than treating the absence of an error as proof of accuracy.
A small worksheet that separates inputs from results
These sample values are fictional and the outputs are independently calculated. Enter inputs in the stated cells and formulas in the separate result cells. Keep this test on a new sheet, apart from your working data.
| Enter inputs | Enter formula in | Formula | Expected result |
|---|---|---|---|
| A2=5; A3=2 | C2 | =A2+A3 | 7 |
| B2=10; B3=20; B4=30 | C3 | =SUM(B2:B4) | 60 |
| No input cells required | C4 | =5+2*3 | 11 |
| No input cells required | C5 | =(5+2)*3 | 21 |
Change B4 from 30 to 40. C3 should become 70. Restore it, then change A2 from 5 to 8: C2 should become 10. These two checks help you distinguish working references from a typed answer.
Before you return to the working workbook
- Confirm that results sit outside their own input ranges; an unintended circular reference needs a corrected reference.
- Check one ordinary input, one empty or zero case, and any important boundary.
- Compare the first and last copied formula, including absolute references.
- Record which source values and expected answers you checked.
For a clean starting example, use our Excel formula templates with row totals and an IF discount. If inconsistent status labels are causing downstream reporting issues, start with a controlled task status dropdown.

