Spreadsheet Formula Error Decoder

Find explanations and fix examples for supported Excel and Google Sheets formula errors.

On-device No sign-up Free to use

Explain formula errors controls

Showing an example. Edit to see your own.

?

Recognizes #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!, #SPILL!, #CALC!, #ERROR!, Circular reference and hash marks.

?

Optional, up to 2,000 UTF-8 bytes. It is shown alongside general checks; it is not evaluated or used to diagnose a workbook.

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

Use #DIV/0! to investigate the divisor in =B2/C2.

#DIV/0!: A calculation divided by zero or by a blank divisor.

Loading the tool. Your result will appear here.

https://usefreetools.net/spreadsheet-formula-error-decoder · 20 November 2026

Was this helpful?

How to use Spreadsheet Formula Error Decoder

  1. Enter the reported error code or display text.
  2. Optionally enter a formula for your own reference.
  3. 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.

You add
Error code or display: #DIV/0!; Formula or context for your reference: =B2/C2
You get
#DIV/0!: A calculation divided by zero or by a blank divisor.

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.

Page updated · Project managed by Tony Hines · Report a problem with Spreadsheet Formula Error Decoder