Excel tutorials

Sometimes when we do calculations in our worksheet we are going to encounter errors – regarding to blank cells, missing values, or division by zero – just to name a few.

In this example we are going to see how we can get rid of the annoying #DIV/0! error – we get that one when we try to divide by zero.

Below we have some data. Column C is the result from dividing values in column A with values in column B. As we can see, we get 2 errors because those are division by zero.

The easiest way to get rid of those, is to replace it with a more user-friendly message. We are going to use the =IFERROR() function.

In column C3 – customize the formula to look like this:

=IFERROR(A3/B3;”Division by zero”)

The first argument is the value, the division in this case, the second is what we want to type if an error occur, here we type “Division by zero”, but we can type what we want to display here.