Divisionn by Zero error


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.


Here is our tutorial on this topic and that tutorial also includes a method of removing errors for Excel 2003 and earlier.


Answer the Question

You must create an account to use the forum. Create an Account or Login