Hide Value of Cell

[Mark]

Hello,

I have a cell (c) with this formula: =(a2/b2)-1.005. I
want to hide the #DIV/0! that appears in the cell when
there is no data in a2 or b2. Is this possible? Thanks
in advance for your help.

Mark

 

[JE McGimpsey]

One way:

=IF(B2<>0,A2/B2-1.005,"")

 

[Guest]

Try:

=IF(B2<>0,(A2/B2)-1.005,"")

Art