| 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 | |||
Hybrid Mode
