Simple IF statement help

beancounter

Board Regular
Joined
Oct 30, 2002
Messages
111
This one is driving me crazy and I've got to get it done.

I have cell C6. It has a drop down box with values: "F,P,N,M,R,T,W,A,C"

I want to write a formula in E6 where if C6 is not either F or P then return "YES" otherwise return "NO".

Everything I've tried either gives me an error or "YES" to any value in C6.

Thanks,
John :oops:
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,645
Members
412,335
Latest member
cinciri99
Top