| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
when IF equals multiple values??
Hello,
This should be easy, although for some reason........ anyway, i'm trying to say this: IF 1or3or5or8or10or12or13or15or17or20 then 1, if not then 2. i understand the basic true or false formula, =if(a1=1,1,2), but how do i string the commands to assign a '1' to any of the ten above mentioned numbers. of course, i'd like the other numbers:2,4,6,7,9,11,14,16,18,19 to be '2'. Any help will be greatly appreciated. Have a Great Day! SF |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria & Count if Equals 0 | Excel Worksheet Functions | |||
| insert row when sum of values equals 100 | Excel Discussion (Misc queries) | |||
| insert row when sum of values equals 100 | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Threaded Mode
