Excel 2016 – What is #DIV/0! error and how to fix it?

by

The #DIV/0! error message means “divide by zero” – a division which is mathematically impossible, hence the error.

When you see this it’s because you have a formula which is trying to divide a number by zero – e.g. 3 / 0

A similar error is #VALUE! – where a formula has tried to do math using using text. – e.g. 3 / text

How do you avoid these errors?

Using the IFERROR function.

IFERROR requires two arguments – 

  • value – this is where you place your forumla
  • value if error – what is displayed if there is an error in the value. This can be a static value or another formula.

For example:

=IFERROR(A2/B2,0)

 

Reference: https://support.office.com/en-us/article/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611