No more #DIV/0!

Add to Favorites
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.

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 ...
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...
PV Function - Get the Present Value in Excel
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment. ...
Increment a Value Every X Number of Rows in Excel
Tutorial: How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial...