Help with condition

[Guest]

I have two columns that I am dividing one column by the other, yet one column
does not match the same amount of numbers. So when this comes up I would like
it to come up with "0" instead of an "error". In actually I am dividing a
number by 0. Any help thanks in advance..

 

[Guest]

Something like:
=IF(ISERROR(A1/B1),0,A1/B1)
should do it.
The error will still be there, but it will display as a 0.

tj

 

[JE McGimpsey]

One way:

Rather than

=A1/B1

use

=IF(B1<>0,A1/B1,0)