View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default condition - member of a group

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

"elbows" wrote in
message ...

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.


--
elbows
------------------------------------------------------------------------
elbows's Profile:

http://www.excelforum.com/member.php...fo&userid=7449
View this thread: http://www.excelforum.com/showthread...hreadid=521772