Help Reg And Function

[Leonardo1234]

Hi,

I have a And function but it is not in correct Logic so plz Help
And (wsh1.Range("M" & l2).Value) > (wsh1.Range("Y" & l2).Value) Or (wsh1.Range("M" & l2).Value) < (wsh1.Range("Y" & l2).Value)

Logic is M > Y Or M < Y

Thnx for the Help

[Marc L]

Logic is M > Y Or M < Y

Hi,

obviously the correct logic must be M <> Y ‼

[Leonardo1234]

Awesome
Great Suggestion
Thnx Alot Sir
Have a Great Day

[Leonardo1234]

Is this the Solution?
And (wsh1.Range("M" & l2).Value) <> (wsh1.Range("Y" & l2).Value)

[vichopalacios]

After reading your posts, I suggest you try the following code 4 times,
each time active one of the commented lines and see what happens.

Sub Learning_And_Or()
Dim M, Y, Answer
M = 1
Y = 2

'Answer = And(M>Y or M<Y)
'Answer = And(M<>Y)
'Answer = M > Y Or M < Y
'Answer = M > Y And M < Y

Debug.Print Answer
End Sub