Problems with Logical Test

[girlyg]

Hello people,

I have two columns and this is what I want:
I have to options I will put either dates on this cells or I will put N/A.

If A4 = B4, "YES"
B4 < A4, "Yes"
A4 and B4 = N/A, "N/A"

If the value is false then I want it to be "NO" and that cell I want it to be with a red font.

The problem I have is that if I have A4=N/A and B4 =N/A, then obviously It going to throw me a result of "Yes", but that's not what I want.

Any ideas on how to solve this issue?

Thanks!

 

[mikerickson]

Try
=IF(OR(A4="N/A",B4="N/A"),"NO",IF(A4=B4,"YES",IF(B4 < A4,"Yes","NO")))

 

[Marcelo Branco]

Hi,

Maybe this (assuming N/A in A4 or B4 are text)


=IF(AND(A4="N/A",B4="N/A"),"N/A",IF(OR(A4=B4;B4 < A4),"Yes","No"))
HTH

M.

 

[Marcelo Branco]

oops

=IF(OR(A4="N/A",B4="N/A"),"N/A",IF(OR(A4=B4;B4 < A4),"Yes","No"))

M.

 

[ukmikeb]

Hi

Or -

=IF(OR(A4="N/A",B4="N/A"),"No",IF(A4=>B4,"Yes","No"))

hth