Course
IFERROR practice exercises
Five exercises, from hiding #DIV/0! to searching a second list when the first lookup fails. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Hide #DIV/0! in a rate
The conversion rate is orders divided by visits. Some campaigns had no visits yet, so =C2/B2 shows #DIV/0!. Fill D2:D6 with the rate, and 0 when it can’t be calculated.
| Campaign | Visits | Orders | Conversion rate |
| Spring newsletter | 1200 | 36 | |
| Trade fair QR code | 0 | 0 | |
| Search ads | 850 | 17 | |
| Partner blog | 2400 | 60 | |
| Radio spot | 0 | 0 |