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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
when IF equals multiple values??
Sub SF()
Dim i As Long Select Case Sheets("Sheet1").Range("A1") Case Is = 1 i = 1 Case Is 1 i = 2 End Select 'Hope It Works!!! End Sub "foamfollower" wrote in message om... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
when IF equals multiple values??
=IF(OR(A1=1,A1=3,A1=5,A1=8,A1=10,A1=12,A1=13,A1=15 ,A1=17,A1=20),1,2)
Alan Beban foamfollower wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
when IF equals multiple values??
"foamfollower" wrote in message
om... 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 formula (there may be better ones): =IF( ISNA(MATCH(A1,{1,3,5,8,10,12,13,15,17,20},0)),2,1) programmatically: If InStr("01?03?05?08?10?12?13?15?17?20", Format(Range("A1").Text, "00")) 0 Then x = 1 Else x = 2 End If -- Bob Kilmer |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
when IF equals multiple values??
"Jose Rojas" wrote in message
... Sub SF() Dim i As Long Select Case Sheets("Sheet1").Range("A1") Case Is = 1 i = 1 Case Is 1 i = 2 End Select 'Hope It Works!!! End Sub Did you mean something like this? Sub SF() Dim i As Long Select Case Sheets("Sheet1").Range("A1") Case Is = 1, 3, 5, 8, 10, 12, 13, 15, 17, 20 i = 1 Case Else i = 2 End Select End Sub -- Bob Kilmer |
Reply |
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) |