Excel Troubleshooting: Find the Cause Before Changing the Formula

A wrong-looking cell is not always a broken formula. First determine whether the problem is its input, calculation, display, access permission or Excel edition. Repair one small example before changing a whole workbook.

Scope: checked October 21, 2026 against Microsoft documentation. The arithmetic exercise below is independently calculated, not executed in Excel. Desktop-only diagnostic tools are identified as such; this page does not claim free Excel for the web has desktop feature parity. No account, application or native screenshot was used for this review.

Preserve evidence first

Keep the original workbook unchanged and use an authorized working copy. Record the cell address, exact formula, displayed result, expected result and the last change before the problem appeared. Note whether you are in a browser, Windows or Mac and identify the edition/build with the version reference.

If saving is uncertain, do not close the only open copy just to restart Excel. If a collaborator changed important data, investigate earlier workbook versions before attempting a large repair. Restoration can affect other people’s subsequent work.

A formula is visible instead of its answer

Inspect the formula bar in the affected cell. A formula needs an initial equals sign; an entry such as SUM(A1:A3) is text, not an instruction to calculate. Check the cell’s format and whether formulas are being displayed before re-entering anything. Microsoft also recommends checking matched parentheses, range punctuation and quoted worksheet names when Excel rejects a formula. See Microsoft’s broken-formula checklist.

For one suspect formula, write a tiny equivalent in an empty practice area. Avoid workbook-wide punctuation replacement: a comma or quote inside text may be intentional. Use the reference-copying guide when the formula works in one row but points to the wrong inputs after copying.

The cell shows an error

Read the error before concealing it. An error-handler returning zero can produce a plausible but false total.

• #DIV/0!: inspect the denominator and its source cells. Microsoft documents division by zero or a blank divisor as causes. Supply a valid denominator only when the underlying observation actually exists; do not invent one. Microsoft’s division-error help.
• #SPILL! in an Excel table: check whether the calculation needs a spilling result outside the table. Follow the dedicated table spill diagnosis rather than deleting nearby data experimentally.
• An error after moving or deleting inputs: compare the current references with the preserved copy. For an external source, use workbook-link diagnosis. Breaking a link is a change to the model, not a neutral repair.
• A complex desktop formula fails: use the scoped dependency tracing and evaluation guide. Do not assume those desktop auditing controls exist in the browser.

Worked diagnostic: missing quantity is not zero cost

In a disposable worksheet, put total cost 84 in A2 and quantity 7 in B2. The formula =A2/B2 should return 12. Change B2 to 0: division has no defined numeric result, so the documented Excel outcome is #DIV/0!. Changing B2 to 14 should return 6.

These expected answers were checked independently by arithmetic. They are not native execution evidence. If the zero represents a missing quantity, label the observation as incomplete and obtain the quantity; replacing the error with zero would incorrectly report free units. If your real formula fails while this small case works, compare its referenced inputs rather than reinstalling software.

The number is present but wrong

Choose the narrowest matching route:

• Old result after editing an input: inspect calculation behavior. The Excel 2013 calculation-mode guide is explicitly historical, not a browser recipe.
• Dates counted incorrectly: check time components and boundaries with timestamp-aware COUNTIFS.
• Imported identifier lost digits or zeros: return to the unmodified source. Formatting cannot recreate destroyed digits. Use the Excel 2013 long-identifier import guide only for that edition’s workflow.
• Only appearance differs: compare the stored value with number/date formatting before changing the data.

Editing or automation is blocked

Resolve sheet protection with the authorized owner, not by bypassing it. A nonworking VBA workflow in the browser is an edition limitation: Microsoft says Excel for the web cannot create, run or edit VBA macros. See Microsoft’s web macro guidance. Preserve the original macro-enabled workbook; do not strip its code to silence the symptom.

When requesting help, provide a sanitized minimal example plus version, platform, exact error and expected answer. Exclude credentials, private workbook links and sensitive source data.

Calculation error reference

For worked examples of specific formula errors, browse the calculation error reference. Use the relevant guide on a disposable example or a copy of your workbook.