Practice challenge
Calculate margin with a zero-revenue guard
#1
3 attempts remaining
BeginnerSalesTarget D2
A shop tracks revenue and cost by product. The margin column should show a percentage when revenue exists and N/A when it does not.
Write a formula for D2 that calculates margin and returns "N/A" when revenue is zero.
Calculate margin with a zero-revenue guard
Swipe horizontally to view the full table.
| A | B | C | D | |
|---|---|---|---|---|
| # | Product | Revenue | Cost | Margin |
| 2 | Matcha Kit | 2,400 | 1,320 | blank |
| 3 | Tea Set | 1,850 | 1,110 | blank |
| 4 | Gift Card | 0 | 0 | blank |
| 5 | Workshop | 3,200 | 1,760 | blank |