IF AND/OR Help!

[ADoc01]

Hi all,

I've nested an if and/or formula and all seems to be working well except for one odd result.

I was wondering if someone could help. Attached is a screenshot.

The formula reads as follows for row 3: =IF(OR(AND(C3="B",D3="S"),AND(C3="S",D3="B"),AND(C3>0,D3<0),AND(C3<0,D3>0)),"TRADE","-")

If there is a B in the first column and an S in the other (same other way around), that should result in Trade.
If there is a positive number in the first column and a negative number in the next (same other way around) that should result in Trade.

The third row is generating Trade when I would like it not to.

If there is an "N" in either the first column or the second, then I would like to generate a "-".

Would someone be able to guide me as to how to nest this in the above formula?

 

[Peter_SSs]

The third row is generating Trade when I would like it not to.

Try this modification

=IF(OR(AND(C3="B",D3="S"),AND(C3="S",D3="B"),AND(ISNUMBER(C3),C3>0,D3<0),AND(C3<0,D3>0,ISNUMBER(D3))),"TRADE","-")

 

[ADoc01]

Peter thank you very much - working perfectly now.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.