IF Statement: i am in this list then discount me?

[antony moseley]

Hi All,

I have a IF statement that a certain cell can not be, however it is more than an IF statement can handle. Does anyone know if you can do a formula that says if i am in this list then discount me?

Thanks

Antony

[DonkeyOte]

You would need to provide more info... do you mean ?

=IF(OR(A1={"a","b","c","d","e","f","g","h","i","j"}),"computer says no","ok")