### Remove Divide by 0 error #DIV/0! with 0

Aug. 14th, 2014 02:07 pm**fuzzygruf**

Errors on the spreadsheet like #DIV/0! are ugly, especially if presenting the data to someone else.

You can use the ISERROR function to take care of a multiple of errors. To get rid of the #DIV/0 error, you *could* use it like so: "=IF(ISERROR(A2/B2),0,A2/B2)" to give you 0. (It reads as "if A2 divided by B2 is an error, return 0, else return the result of A2 divided by B2.)

But for #DIV/0! errors, it's easier for me to write: "IF(B2=0,0,A2/B2)" to give you 0. (It reads as "if B2 is zero, return 0, else return the results of A2 divided by B2.)

## no subject

Date: 2014-08-15 02:16 pm (UTC)ricksf.livejournal.com