Maximizing Connectivity & Productivity

Reduce the #DIV/0! error in Excel

If you know your formula is correct, and it is okay for the column being used in the division to have a zero, (and you don’t want your end user to think your spreadsheet is wrong), then your formula should use the IF statement. 

Ex. If  A2/B2=0 and it is okay for column B to sometimes have the value of 0, then you can use the formula IF(b2=0,””,A2/B2).  Using the “” will have the effect of creating a blank value in the cell, instead of the #DIV/0!.  Alternatively, instead of using “”, a string value such as “Check the value in Col B” can be used.

Leave a Reply

You must be logged in to post a comment.

Mississauga, ON, Canada 905.607.3500