Or Statement

[techstyle20]

Hi,

I need to add an additional argument to the following:

=(IF(AND(D12=0,E12<>0),(-100%+I7),((D12-E12)/D12)-I7))

This works fine until there is a "0" (zero) in both D12 & E12 as it is dividing itself by zero and I get the #DIV/0! error.

I need this to input "-" if both D12 & E12 contain "0" (zero)

Thanks in advance!

 

[Rick Rothstein]

I don't think you have to worry about E12 being 0... the error is raised only when D12 is 0. Give this a try...

=(IF(AND(D12=0,E12<>0),(-100%+I7),IF(D12=0,"-",((D12-E12)/D12)-I7)))

 

[techstyle20]

Brilliant Rick,

Thats perfect.

I think I stared at it too long!

Thanks.