If problem...

[Stephen]

Hi Folks,

I'm trying to say "Cell 3 = If cell 1 & cell 2 = 0 then "" else (cell 1 -
cell 2) / cell 2.

But I can't get that to work as a fomula.

help!

 

[Carim]

Hi,

See below :

=IF(AND(A1=0,A2=0),"",(A1-A2)/A2)

HTH
Carim

 

[JLGWhiz]

=IF(AND(A1=0, B1=0), "",(A1-B1)/B1)

 

[Stephen]

perfect thank you!

=IF(AND(A1=0, B1=0), "",(A1-B1)/B1)