easyPetronas · logical
Average downtime per incident, without erroring on zero incidents
Column A holds total downtime (hours) per piece of equipment, column B the number of incidents. Some equipment had zero incidents. Write formulas in C1:C3, one per row, that compute average downtime per incident, returning 0 instead of an error when there were no incidents.
Starting grid
A1
| A | B | C | |
|---|---|---|---|
| 1 | 120 | 4 | |
| 2 | 0 | 0 | |
| 3 | 45 | 3 |
Show expected output▾
Stuck? Ask the coach for a nudge that won't give the answer away, or reveal the reference solution and a short walkthrough of why it works.
C1
| A | B | C | |
|---|---|---|---|
| 1 | 120 | 4 | |
| 2 | 0 | 0 | |
| 3 | 45 | 3 |