condition - member of a group

E

elbows

Hi.

I want to make the condition of my if-then statement be whether a value
is either 10,11, or 12. I can't find an "in" function or something like
that.

Can someone tell me how to do this?

Thanks.
 
B

Bob Phillips

=IF(OR(A1=10,A1=11,A1=12),...

or

=IF(AND(A1>=10,A1<=12),...

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Guest

Hi

In its simplest form, you could use this:
=IF(OR(A2=10,A2=11,A2=12),"Yes","No")

Hope this helps.
Andy.
 
Top