Basic Iferror exercise

In this exercise, we’re looking at the Iferror function. This function can be handy when you expect errors to exist, but you want to handle them gracefully.

In the exercise, we are expecting an error, namely a #DIV/0! error that you get when you divide a number by 0. Since that’s not allowed in mathematics, the error is reasonable, yet we still would like to return something other than an error. That’s where Iferror comes in.

Return the number of Drinks per guest in cell C4. You can do this by dividing the number of drinks by the number of guests. Since there are 0 guests this time, we will run into a #DIV/0! error. In the interactive spreadsheet editor, you will actually get Infinity as the answer, but you can treat this as if it said #DIV/0!.

When you get this error, use the division as one of the arguments of the Iferror function to return the result of the division if there is no error and 0 otherwise.

Spreadsheet editor
Great work!

Related functions


Leave a Comment