"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Avoid #DIV/0! Errors

One of the most common questions Iím asked in Excel is how to deal with #DIV/0! errors.

It's common to get #DIV/0! errors in worksheets that contain formulas with division operations. This error results from the divisor part of a division formula referring to a cell that is blank or has a zero value.

There is no perfect solution for this problem. Most times you'll want to know that a formula is trying to divide a number by zero, but there may be times where you want to suppress this error for reporting purposes.

You can modify your formula to display either a blank or a zero whenever the formula results in an error. Use one of these formulas:

  • =IF(ISERROR(formula),"",formula) or
  • =IF(ISERROR(formula),0,formula)

Just substitute your original formula for the word formula.

Keep in mind that, technically, a 'blank' or 'zero' answer is incorrect. You cannot divide a number by zero. Use this with caution.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright © 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.