Practice challenge
Calculate a sales conversion rate
#15
3 attempts remaining
BeginnerSalesTarget D2
A sales funnel sheet tracks leads and customers by channel.
Write a formula for D2 that returns the conversion rate and "N/A" when leads are zero.
Calculate a sales conversion rate
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Channel | Leads | Customers | Conversion |
| 2 | Website | 450 | 36 | blank |
| 3 | Referral | 120 | 18 | blank |
| 4 | Events | 0 | 0 | blank |
| 5 | 300 | 27 | blank |