Compounded If Or Statement

[schmitkl]

Good morning all! I need a formula that does the following:
If one cell is negative and the other is positive return NA, but if both are positive or both are negative D4 (for example)

I know it should be something along the below, but not sure how to write it to function properly. Thank you in advance!
If C4 < 0 and D4 > 0, or if C4 > 0 and D4 <0 return NA but if C4 <0 and D4 <0 or C4 > and D4 >0 return D4.

 

[Fluff]

How about
=IF(OR(AND(C4<0,D4<0),AND(C4>0,D4>0)),D4,"NA")

 

[Pumperkin]

Hi,

Please see below - I started with C2 and D2 but the gist is there:

=IF(C2<0,IF(D2<0,D2,"N/A"),IF(D2>=0,D2,"N/A"))

Please let me know if you need anything clarifying or it doesn't work (I tried for a set of data and seemed to work, but you never know).

 

[schmitkl]

Thank you! Thank you!!

 

[Fluff]

Glad we could help & thanks for the feedback