[RESOLVED] [2008] How to check if number between 2 numbers

[mahammad()]

hi all

How can I check if number is between to numbers using select case
for example to know if it's between 0-5 or 5-10 or 10-15

please help

thanks

[jmcilhinney]

Select Case myNumber
    Case 0 to 5
 
    Case 6 to 10
 
    Case 11 to 15
 
    Case Else
 
End Select

or

Select Case myNumber
    Case Is <= 5
 
    Case Is <= 10
 
    Case Is <= 15
 
    Case Else
 
End Select

The first one will work for whole numbers only. The second will work for floating-point numbers too.

[mahammad()]

I have tried it but I typed it wrong
like this

select case mynumber
case is 0 to 5

so it didn't work
but the one you typed worked

thank you for helping

[jmcilhinney]

You only use 'Is' when the Case expression starts with an operator rather than a value.

[mahammad()]

ok thanks

[aashish_9601]

The first one will work for whole numbers only. The second will work for floating-point numbers too.

jmcilhinney Can you please elaborate as to why it behaves like this

[jmcilhinney]

jmcilhinney Can you please elaborate as to why it behaves like this

I'm glad you asked because it made me realise that it's actually not true. They'll both work for floating point values.

[Link]

Dim number as Integer = 7
 
If number > 5 and number < 10 Then
' The number is between 5-10
End If

Thats i a method too i guess..

[noahssite]

What link wrote was what i was thinking.. but then i saw that you asked for it in the select case format.

[jmcilhinney]

I'm glad you asked because it made me realise that it's actually not true. They'll both work for floating point values.

Further to this, the range will work for floating point numbers within the range but it won't catch number between 5 and 6 or numbers between 10 and 11, so it actually isn't suitable for most scenarios where the number may not be whole.