| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
condition - member of a group
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
condition - member of a group
Hi
In its simplest form, you could use this: =IF(OR(A2=10,A2=11,A2=12),"Yes","No") Hope this helps. Andy. "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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
condition - member of a group
Thanks. That helps. -- elbows ------------------------------------------------------------------------ elbows's Profile: http://www.excelforum.com/member.php...fo&userid=7449 View this thread: http://www.excelforum.com/showthread...hreadid=521772 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table to calc by group | Excel Discussion (Misc queries) | |||
| format group of rows based on condition | Excel Discussion (Misc queries) | |||
| Calculate cell row and column | Excel Discussion (Misc queries) | |||
| Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
