If Range > Or Range < And Range >

[288enzo]

I couldn't find any examples of using "And" & "Or" in an If statement. Is that because you can't?

My formula is giving me an N/A, is it because of what I said above, or do I have it out of order?

If Range("W" & x) > 10 Or Range("W" & x) < -10 And Range("X" & x) > 1 Then

Thank you

 

[288enzo]

deleted

 

[288enzo]

Figured it out, I had to swap them around. Go figure.

If Range("X" & x) > 1 And Range("W" & x) > 10 Or Range("W" & x) < -10 Then

 

[StephenCrump]

The expression will be evaluated based on operator precedence: Arithmetic operators (none in this example) before Comparison operators (you are using < and >) before logical operators (you are using And, Or).

Because comparison operators are evaluated before logical operators, you are able to write:

If Range("W" & x) > 10 Or Range("W" & x) < -10 And Range("X" & x) > 1 Then
'rather than
If (Range("W" & x) > 10) Or (Range("W" & x) < -10) And (Range("X" & x) > 1) Then

There is an order of precedence for logical operators (e.g. And before Or) in the same way that there is an order of precedence for arithmetic operators (e.g. ^ before * before +).

'Therefore your first statement:
If Range("W" & x) > 10 Or Range("W" & x) < -10 And Range("X" & x) > 1 Then
'ís equivalent to
If Range("W" & x) > 10 Or (Range("W" & x) < -10 And Range("X" & x) > 1) Then

'... and your second statement:
If Range("X" & x) > 1 And Range("W" & x) > 10 Or Range("W" & x) < -10 Then
'ís equivalent to
If (Range("X" & x) > 1 And Range("W" & x) > 10) Or Range("W" & x) < -10 Then

There is a third possibility which I am guessing might be the one you actually want?

If Range("X" & x).Value > 1 And (Range("W" & x).Value > 10 Or Range("W" & x).Value < -10) Then
'which you could also write
If Range("X" & x).Value > 1 And Abs(Range("W" & x).Value > 10) Then