How to use Spreadsheet Formula Error Decoder
- Enter the reported error code or display text.
- Optionally enter a formula for your own reference.
- Read the general checks and compare the example with your sheet.
Example: Spreadsheet Formula Error Decoder
Use #DIV/0! to investigate the divisor in =B2/C2.
Options
- Error code or display
- Recognizes #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!, #SPILL!, #CALC!, #ERROR!, Circular reference and hash marks.
- Formula or context for your reference
- Optional, up to 2,000 UTF-8 bytes. It is shown alongside general checks; it is not evaluated or used to diagnose a workbook.
Supported inputs and limits
- Reference advice, without reading or calculating your workbook.
- Expand an error example, select it for diagnosis or use its page anchor.
- Syntax and available functions vary by spreadsheet/version.
- Examples describe common causes; they do not establish the cause in an unseen sheet.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Check the cause before hiding an error
For #DIV/0!, inspect whether C2 is zero, blank or produced by another formula. The error label narrows the investigation but does not establish the cause in an unseen sheet. Adding IFERROR can hide a bad input or broken reference. Use the code-specific checks, then test a change in your spreadsheet; this decoder does not edit or evaluate it.
Questions about Spreadsheet Formula Error Decoder
Does the context change the diagnosis?
No. It is shown for your reference. The checks describe the recognized error; the tool does not evaluate your formula.
Does IFERROR fix every problem?
It can hide the error without correcting its cause. Check the underlying references and inputs first.
What does circular-reference guidance cover?
Checks for a formula depending on itself through its references. The tool does not discover those relationships in a workbook.