#DIV/0! Error & IF, THEN Condition Formula

[Jeani]

Here is what I am doing, C1 = A1/B1. C1 is the % difference between A1 & B1.
A1 & B1 are $. When there are 0s, of course, I get the #DIV/0! error. I think
I need to enter an "IF, THEN" condition formula to illiminate this error, but
have been unsuccessful thus far. Can anyone help?

 

[Thad Student]

This should work:
=IF(B1<> 0, A1/B1,"")

 

[ShaneDevenshire]

Hi.

try =IF(B1=0,"",A1/B1)
or
=IF(B1=0,0,A1/B1)