A rate that cannot divide by zero
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
The signup rate is signups divided by clicks. A campaign with no clicks must show 0 instead of an error. Fill D2 to D4 using IFERROR.
What this exercise teaches
Dividing by zero returns #DIV/0!, and one error breaks every total built on that column. IFERROR swaps the error for a value you choose. Wrap only the part that can fail, so other mistakes still show.
A hint if you get stuck
IFERROR(formula, value to show when the formula fails). Put the division first and 0 second.
Try it now, free, no account needed
Your first 15 exercises on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exercise