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.)
I use the following formula to eliminate Div by Zero error in my spreadsheets.
=IF($C$7=0,0,(B17/$C$7)) So if $C$7 is Zero, a zero will apear in the cell and other following calculations will not error out. It just means there is not a value to be added from $C$7 at this time.
Years ago I had software that in the parameters you set Div by zero = 0 or Div by zero = error.
My question is: Has Excel added this setting or is there a better way to do what I am doing?
You can use the IFERROR() function in Excel 2007 and later versions.
=IFERROR(B17/$C$7,0)Here is our tutorial on this topic and that tutorial also includes a method of removing errors for Excel 2003 and earlier.