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!

 

[VoG]

Try

=LOOKUP(A1,{"BLANK","NO","YES"},{"BLANK","FALSE","TRUE"})

 

[Scott R]

=if(c1="","",if(c1="yes",true,false))

 

[forbudt4u]

VoG... this formula worked for the YES (TRUE) / NO (FALSE) results, but the blank's give me an "N/A" error. I've tried replacing the two "BLANK" with """", and that didn't fix it either... suggestions?

 

[VoG]

Try

=IF(A1="","BLANK",IF(A1="YES",TRUE,FALSE))

 

[forbudt4u]

Scott & VoG, both of your IF formulas fixed the blank issue, but now it's only giving me a result of FALSE if YES or NO is chosen.

 

[VoG]

Are you sure it is "YES", not " YES" or "YES " for example.

It works for me by the way.

 

[forbudt4u]

I copied the formula you wrote and changed the Cell to the cell I'm using. However, I did go back through to make sure I didn't accidentally mess with the quotation symbols and I have not. I also went back to make sure both cells (formula and reference) are the same type and they are (general). You don't think it's because the reference cell is a dropdown box instead of a manual entry, do you?

 

[Scott R]

Case sensitive problem? You want to mimic the case of your dropdown list in your formula.

 

[VoG]

As above check for leading or trailing spaces in your allowed values (Data Validation list).

Excel Workbook
	A	B
1	NO	FALSE
2	YES	TRUE
3		BLANK
Sheet9