PDA

View Full Version : Solved: IF Statement Help



Dimitriy
08-03-2009, 06:26 AM
Hey Everyone,

I am stuck with what seems to be an easy issue. I want to set up an IF statement that references a data validated cell. Please see the attachment. I want to be able to display the word "Dinner" whenever anything that end with a letter "D" is selected in the first dropdown. Thanks in advance.

mdmackillop
08-03-2009, 06:48 AM
=IF(ISERR(FIND("D",$B$1)),"No","Dinner")

Dimitriy
08-03-2009, 08:57 AM
Thank you!