Avoid #DIV/0! with IFERROR

Premium

The lamp has not sold yet, so B2/C2 gives #DIV/0!. In D2, wrap B2/C2 in IFERROR to show 0 instead.

D2
ABCDEF
1Product Revenue Units sold Price per unit
2Desk lamp 0 0
3
4
5
6
7
8

Premium lesson

Unlock IFERROR and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?