Sheetsdrill

Level 1: Basics Exercise 13 of 92

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.

Functions used: IFERROR

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

More exercises in Basics