Excel + Google Sheets · IFERROR

Hide every #DIV/0!

Shows your own value instead of an error.

The formula

=IFERROR(A2/B2, 0)

What each part means

A2/B2Your normal formula
0What to show if it fails

Example

Before

	A	B	C
1	Sales	Visits	Rate
2	30	600
3	12	0
4	45	300
5	8	200

After

	A	B	C
1	Sales	Visits	Rate
2	30	600	5.0%
3	12	0	0
4	45	300	15.0%
5	8	200	4.0%

Step by step

Click cell C2.
Type the formula: =IFERROR(A2/B2, 0)
Press Enter.
Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.

Where it works

Every version of Excel
Google Sheets
Excel for the web (free)

The same formula in other languages

English IFERROR
Español SI.ERROR
Português SEERRO

Get 1 formula a day, free

Plus a free weekly planner template for Excel and Google Sheets. Unsubscribe in 1 click.

✓ Done! Check your inbox to confirm.

Want ready-made templates? See the Formulyo pack →

Keep learning

Running totalRunning totals with one $Progress %Project progress in one cell &Join cells with one symbol ROUNDRound any number the right way % of totalThe $ that saves your formulas TEXTSPLITSplit text into columns with a formula