Community
Hi,
Is there a way to use SELECT CASE with (e.g. <=) operators??? Or am I forced to use (If Then Else) clause?
Select springModel
Case "Spring2"
Select load
Case <= 75
Return "White"
Case <= 160
Return "Yellow"
End Select
End Select
Regards,
Solved! Go to Solution.
Solved by justinrice. Go to Solution.
Andrew,
The following should do it:
Select springModel Case "Spring2" Select True Case load <= 75 Return "White" Case load <= 160 Return "Yellow" End Select End Select
Let me know if you need any further assistance,
Justin