Divided by zero

[Guest]

Hi All,

I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1
equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0!

Plz help

Regards

Hassan

 

[Guest]

=if(iserror(a1/b1),0,a1/b1)

or

=if(b1=0,0,a1/b1)

 

[Gordon Rainsford]

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

Hi All,

I have two cells e.g. a1 & b1 and c1 contains the formula =a1/b1, if b1
equals to 0 then i need that formula returns 0 in c1 instead of #DIV/0!

Plz help

Regards

Hassan