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

  • Thread starter Thread starter Jeani
  • Start date Start date
J

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?
 
Back
Top