Level 2LogicPractice, 3 min
IFERROR: no more #DIV/0!
The task
Cost per lead is spend divided by leads, but two channels had zero leads. In D2, fill the whole column with one formula:
ARRAYFORMULA around spend divided by leads, wrapped in IFERROR so the zero-lead rows say No leads.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Channel | Spend | Leads | Cost per lead |
| 2 | Search | $4,200 | 120 | |
| 3 | Social | $2,600 | 0 | |
| 4 | Display | $1,500 | 50 | |
| 5 | $300 | 25 | ||
| 6 | Podcast | $1,800 | 0 |