No more #DIV/0!
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 VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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...
Tutorial: Here, I'll teach you what the errors in Excel mean. There are many errors that you can...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range 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...
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...
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...
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: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Tutorial Details
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)