Excel: investigate a formula error without hiding it

An error can indicate a missing value, changed reference or unsupported calculation. Replacing every error with zero can hide a real problem.

How to investigate a formula error without hiding it

  1. Keep a copy and select the affected cell.
  1. Read the exact error, such as #DIV/0! or #REF!, and inspect the formula bar.
  1. Check the referenced cells, range and expected input values.
  1. Use the available formula error-checking controls if your Excel version provides them.
  1. Test any correction on sample data and compare the result with an independent calculation.

Practical guidance

Errors such as #DIV/0!, #REF! and #VALUE! indicate different causes. Read the error before replacing the formula with a fixed number.

If the usual instructions do not resolve it

Check referenced cells and recent row or column deletions. Keep a working copy so the original formula is recoverable.

Still need help?

Send the formula, error text and anonymised input values to IT. Do not enable macros or download a spreadsheet repair tool to remove an error.

Official product help

Still need help?

Send a request and include the steps you already tried.

Submit a ticket

Rate this article

How useful was this article?
Add a correction or suggestion (optional)
Do not include passwords, pupil details, or other private information.