I know you can use Select case statements to cover a range of integer
values, such as:

Case 100 To 500
Case 501 to 650
etc

However, I'm not clear on how to work with non-integer values to ensure that
every possible value is covered, while ensuring no overlap in categories.
With an IF statement I might use:

If x 100 and x <=500
elseif x 500 and x <=650

which would properly assign a value of 500.4395 to the second condition

Is there a way to do this with select case? Or is my best option to try to
use more decimals than the data might need, e.g.

Case 100 To 500
Case 500.000001 to 650

Thank you,
Keith