Hints and tips home » Excel hints and tips » Stop Formula Returning A "#DIV/0" Error

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

Added by Carlos on 24th November 2006

More Excel hints and tips, like:

• Outlining - ungrouping rows or columns
• Colouring cells containing formulas
• Quickly Adding New Worksheets