If, and, or conditions...

[albertc30]

Hi all.

This lats part of my formula is wrong somehow as it will not return the expect "not".

=IF(OR(A2>0,B2>0)*AND(D2=0),"No Inp.",IF(AND(A2=0,B2=0,OR(D2>0)),"No prod.",IF(OR(J2<=1%,J2>=-1%),"Yield Ok","not")))

In cell J2 my value is 4.76% as a result of formula "=100%-D2/I2".

According to my previous ifs formula I should now see being returned "not" correct?

What am I doing wrong here please anyone?

Many thanks.

Albert

 

[Special-K99]

What are the values of A2 B2 and D2 in that situation?

Could you supply a dummy spreadsheet?

UPDATE: I dont like that second condition OR(D2 > 0)

D2 > 0 OR....?

 

[bschwartz]

It should return "Yield Ok" because the OR formula >=-1% will return a TRUE. You need to change that to an AND function.

 

[albertc30]

It should return "Yield Ok" because the OR formula >=-1% will return a TRUE. You need to change that to an AND function.

Hey New York, lovelly city.

You are correct.

I can now see the way of my errors.

Apologies to all for the late reply.

Many thanks for all the input. Much appreciated.

Regards,
Albert

 

[bschwartz]

You're most welcome. Thanks for reporting back.