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
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