No more #DIV/0!

Add to Favorites
Author: N/A
It is a frustration if your Excel calculation results show as #DIV/0!, especially if you are expecting to use this cell/range for other cells calculation. This "bad apple" is enough to make the whole calculations effort go into the drain. Why not to replace the #DIV/0! with something more meaningful, for example, zero or just a simple text "N/A".
 
If you are using MS Excel 2003 version and below, you can try this method:
 
= IF (ISERROR(A1), 0, A1)
 
This formula will return 0 (zero) if A1 has zero division error (or any other errors).
 
If you are using MS Excel 2007 (or above), you can try this method:
 
= IFERROR(0, A1)
 
This formula is doing the same as IF/ISERROR, returning 0.

Question? Ask it in our Excel Forum


Excel Function: IF(), IFERROR(), ISERROR()

Similar Content on TeachExcel
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
Make Y Axis Start at 0 in Charts in Excel
Tutorial: How to make the Y axis start at 0 in charts in Excel. This is a simple formatting issue. S...
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...
Multi-Column ComboBox Drop Down Menus in Forms
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Tutorial Details
Excel Function: IF(), IFERROR(), ISERROR()
Similar Content
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...
Formula to Get Value of Last Non-Empty Cell in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel....
Make Y Axis Start at 0 in Charts in Excel
Tutorial: How to make the Y axis start at 0 in charts in Excel. This is a simple formatting issue. S...
Excel Forum