Why doesn't it get "Yes"?

K

Korriet

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to keep formula and be able to input value in cell? 0
Nested If 3
Copying Conditional Formatting 2
Calculate difference in dates 11
formula if one cell doesn't equal another cell 4
Why is this not working? 6
Cells act as if they are linked-link does not display in entry bar 1
trying to make a cell either blank or zore value 4

Top