ExcelBanter - If problem...

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If problem... (https://www.excelbanter.com/excel-programming/402411-if-problem.html)

Stephen[_24_]

If problem...

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

If problem...

Hi,

See below :

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

HTH
Carim

JLGWhiz

If problem...

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

"Stephen" wrote:

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!

Stephen[_24_]

If problem...

perfect thank you!

"JLGWhiz" wrote:

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

"Stephen" wrote:

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!

All times are GMT +1. The time now is 01:14 AM.