Lab › Fixes & Errors › Fix #DIV/0! with IFERROR
Fix #DIV/0! with IFERROR: Excel Lab
Lab 21 · BeginnerIFERRORDivision
The task: Average sale per order = Sales ÷ Orders. People with 0 orders give #DIV/0!. Show 0 instead.
1 Watch how it is done
Step 1: Divide, and catch the error
=IFERROR(B4/C4,0)- Click D4.
- Type =IFERROR(B4/C4,0) and press Enter.
- If B4/C4 is an error, IFERROR shows 0 instead.
- Drag the fill handle down.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Fix #N/A: Code Not Found →
Want the theory? Read the Fixes & Errors lessons →
← More Fixes & Errors labs · All lab categories
