Why doesn't it get "Yes"?

Joined
Mar 31, 2011
Messages
2
Reaction score
0
If D6 = YES, why does this formula not get the answer "YES"?

=IF(D6="N/A","N/A",IF(D6="NO","N/A",IF(D6="YES","YES","NO")))

I've tried it the other way around making the first test "YES" as below but that does not work either.

=IF(D6="YES", "YES", IF(D6="NO,"N/A",IF(D6="N/A","N/A","NO")))

HELP!!
 
Back
Top