Simple IF statement help

[beancounter]

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

 

[Scott Huish]

=IF((C6="P")+(C6="F"),"YES","NO")

 

[beancounter]

That's it!

Thank you - I guess I'm still a safe distance from genius.