Between two numbers

[ksilenio]

Hi to all . I want to write a statement with an " if " between two numbers , how can it be done? eg If 150 between 100 and 200 then ... "do something" end if
Regards

[snb]

In A1: 30
In A2:200
In A3:100

=INT(A1/(A2-A3))=0 

[ksilenio]

Hi thank you for your answer but i don't understant , how can i use this in the VBA code , what i want is how to syntax the "if" statement

[p45cal]

If number1 >100 and number1 < 200 then
'...do whatever you want done
End If

or on one line:

If number1 >100 and number1 < 200 then '...do something

where number1 is a variable containing your number (150 in your example).

[snb]

Sub M_snb()
   x = 99
   y = 200
   Z = 100
   If Int((x - Z) / (y - Z)) = 0 Then MsgBox x & " lies between " & Z & " and " & y
End Sub 

[ksilenio]

OK Thank you

[Paul_Hossler]

Personal style

1. I find it's better if I use parentheses to group each part of the AND

2. I like to arrange the conditionals is what to me is a logical order based on the way I think

L <= N <= H

3. I don't see any reason to squeeze everything onto one line since I find it can make things harder to read

Just seems to make it easier for me

Sub test()
    Dim n As Long, L As Long, H As Long


    n = 150
    L = 100
    H = 200
    
    If (L <= n) And (n < H) Then
        MsgBox n & " is between " & L & " and " & H
    Else
        MsgBox "nope"
    End If


End Sub

If you had to do a lot, you could make a boolean function. It's simple, but might make it easier to follow the logic. Probably costs a few insignificant CPU cycles

Sub test2()
    Dim N As Long, L As Long, H As Long


    N = 150
    L = 100
    H = 200
    
    If Between(L, N, H) Then
        'Do Something
    End If


End Sub




Function Between(L As Variant, N As Variant, H As Variant) As Boolean
    Between = (L <= N) And (N < H)
End Function