Prev: Complex Excel formula help
Next: Search for userform or procedure name?
From: Rick Rothstein on 22 Mar 2010 12:25
In the worksheet world, OR is a function (hence, the arguments enclosed
within its parentheses); however, in the VB world, Or (along with And, Xor
and a couple of others) are operators just like =, <>, >=, etc. are and, as
such, it goes between the "operands" it is being used with. So, it would be
used like this...

If Condition1 Or Condition2 Then

--
Rick (MVP - Excel)



"Papa Jonah" <PapaJonah(a)discussions.microsoft.com> wrote in message
news:BFE80E6C-20B8-4663-B2D9-D70DC485142F(a)microsoft.com...
> 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: Joe User on 22 Mar 2010 12:34
"Papa Jonah" <PapaJonah(a)discussions.microsoft.com> 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.

Just as you wrote it:

If this Or that Then doThis

where "this" and "that" are expression like x<1 and 10<x.

But beware: all expressions are evaluated. So, for example, you might want
to write the following:

If x>0 And y/x > 10 Then doThis

thinking that the x>0 condition protects against a div-by-zero error in
y/x>10. It does not! You have to write something like:

If x>0 Then
If y/x > 10 Then doThis
End If

Similar situations arise with Or, of course.

From: Papa Jonah on 22 Mar 2010 14:14
Thanks again Mike

"Mike H" wrote:

> 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
First  |  Prev  | 
Pages: 1 2
Prev: Complex Excel formula help
Next: Search for userform or procedure name?