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
- Keep a copy and select the affected cell.
- Read the exact error, such as #DIV/0! or #REF!, and inspect the formula bar.
- Check the referenced cells, range and expected input values.
- Use the available formula error-checking controls if your Excel version provides them.
- 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.
Still need help?
Submit a ticket
Send a request and include the steps you already tried.