| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking an array
Hi, I want to check if a value is one of 20 values.# Rather than have IF value = 1 OR value = 2 OR value = 3 etc.. is there a way to have IFvalue within {1,2,3,4,5....} Thank -- wardide ----------------------------------------------------------------------- wardides's Profile: http://www.excelforum.com/member.php...fo&userid=1502 View this thread: http://www.excelforum.com/showthread.php?threadid=27447 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| Make list of cells in array and checking for duplicates | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Checking Number of Dimensions In Array | Excel Programming | |||
![wardides[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
