Code:
Function Score2Grade(dScore As Double) As Double
MsgBox dScore
Select Case dScore
Case Is < 283.2
Score2Grade = 5
Case 283.21 To 307.8
Score2Grade = 4
Case 307.81 To 332.2
Score2Grade = 3
Case 332.21 To 380
Score2Grade = 2
Case Is > 380
Score2Grade = 1
Case Else
Score2Grade = Null 'Unexpected Case, all to throw error message
End Select
End Function
MsgBox Return 332.2
Does anyone know why it gets caught at Case Else?
I was expecting it go return Score2Grade = 3 since it's inclusive.