divide by 0

[Rick Oakley]

I have a formula that divides some values. At times it
divides by zero. I don't care if it does I just don't want
to see it in the cell. How do I hide that message and show
the other valus?

 

[Bernard Liengme]

Let's say your formula is =A2/B2
Replace this by =IF(B2<>0,A2/B2,"")