Prev: Complex Excel formula help
Next: Search for userform or procedure name?
From: Papa Jonah on 22 Mar 2010 11:45
I would like to have an IF Then statement that is of the ilk, If this or that
then...
How do I put the "or" part of it in there? I know how to do the or(x,y)
thing in a worksheet.
Thanks,
Papa J
From: Gary Brown on 22 Mar 2010 11:53
=if(or(a1=1,a2=10),"Yes","NO")
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Papa Jonah" wrote:

> I would like to have an IF Then statement that is of the ilk, If this or that
> then...
> How do I put the "or" part of it in there? I know how to do the or(x,y)
> thing in a worksheet.
> Thanks,
> Papa J
From: ryguy7272 on 22 Mar 2010 11:59
This link seems pretty decent:
http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/

Look at this example:
=IF(OR(B6<$B$2,B6>=$B$3),”No bonus”, B6*$B$1)
(it's a few clicks down the page...)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Papa Jonah" wrote:

> I would like to have an IF Then statement that is of the ilk, If this or that
> then...
> How do I put the "or" part of it in there? I know how to do the or(x,y)
> thing in a worksheet.
> Thanks,
> Papa J
From: Mike H on 22 Mar 2010 12:01
Hi

If x = 1 Or y = 2 Then
'do something
Else
'do something else
End If


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Papa Jonah" wrote:

> I would like to have an IF Then statement that is of the ilk, If this or that
> then...
> How do I put the "or" part of it in there? I know how to do the or(x,y)
> thing in a worksheet.
> Thanks,
> Papa J
From: Sheeloo on 22 Mar 2010 12:06
IF (cond1 OR Cond2) Then
....
Else
....
End If

eg.

Sub test()
If ((Range("a20") = 10)) Or (Range("B20") = 5) Then
MsgBox "Either A20 is 10 or B20 is 5"
Else
MsgBox "both are false"
End If
End Sub
"Papa Jonah" wrote:

> I would like to have an IF Then statement that is of the ilk, If this or that
> then...
> How do I put the "or" part of it in there? I know how to do the or(x,y)
> thing in a worksheet.
> Thanks,
> Papa J
 |  Next  |  Last
Pages: 1 2
Prev: Complex Excel formula help
Next: Search for userform or procedure name?