Puzzling IF Statement

[forbudt4u]

I've tried searching the forum for this answer and I can't exactly find the answer I'm looking for. I'm not even sure if this will require an IF Statement or VLookup?

I have a couple of cells that have a drop down with 3 available answers:

YES
NO
BLANK

I want to create a formula that references the said cell's value but results in producing the following:

If cell = YES, then the result would be TRUE
If cell = NO, then the result would be FALSE
If cell = BLANK, then the result would be BLANK

I could have used a checkbox instead of a YES, NO or BLANK answer, but checkboxes are hard to see for some of our users... hence the reason for having this issue. Any help would be appreciated!

 

[forbudt4u]

Figured it out due to the Data Validation pointer you gave. There was not a leading or trailing space, but the cell with "YES" in it was a listed as a Text type cell. I changed it to General and it fixed it.

That does the trick... again, the board comes through. Thanks guys!!!