One way:

Rather than

=A1/B1

use

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

In article ,
"Mike Busch" wrote:

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