The #DIV/0! error happens when the denominator (the number on the bottom) of an equation is zero. Many times you will want to display a 0 or NULL rather than the #DIV/0! error. Below is a simple way to accomplish this.

Rather than entering =A1/B1, use =if(B1=0,0,A1/B1), if you want a NULL to appear rather than zero, enter =if(B1=0,”",A1/B1).

Joseph Harris
Excel Help
Excel Vlookup Add in

Related posts:

  1. #VALUE! Error in Microsoft Excel The #VALUE error is an error that is seen almost...
  2. How to Use ISERROR Function in Excel The ISERROR function is a versatile one that is very...
  3. Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...

This entry was posted on Tuesday, March 17th, 2009 at 1:47 pm and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.