Help with condition

M

Mike Busch

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..
 
T

tjtjjtjt

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
 
Top