Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Or in an If statement
Can I write and If statement saying
"If citeria is matched or_ citeria is matched or_ citeria is matched then do something end if" Can you use or instead of doing a bunch of else if? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Or in an If statement
e.g.
=IF(OR(A1=1,A1=3,A1=7);1,0)) if you mean a formula |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Or in an If statement
No I am trying to write it in VBA and I'm not really sure ho wto do that.
Thanks though "Jarek Kujawa" wrote: e.g. =IF(OR(A1=1,A1=3,A1=7);1,0)) if you mean a formula |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Or in an If statement
the answer to yr original question is yes
Sub sth If cells(1,1).value = 1 or _ cells(1,1).value = 3 or _ cells(1,1).value = 7 Then cells(1,2).value = "YES" End if End Sub |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Or in an If statement
that worked, thanks
"Jarek Kujawa" wrote: the answer to yr original question is yes Sub sth If cells(1,1).value = 1 or _ cells(1,1).value = 3 or _ cells(1,1).value = 7 Then cells(1,2).value = "YES" End if End Sub |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Or in an If statement
The syntax is
IF(logical_test, value_if_true, [value_if_false]) Replace "logical_test" with citeria is matched or citeria is matched or citeria is matched Jase wrote: Can I write and If statement saying "If citeria is matched or_ citeria is matched or_ citeria is matched then do something end if" Can you use or instead of doing a bunch of else if? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |