What do you mean by: I would like to select on cases with negative values ?
How about: Case is < 0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mike V" wrote in message
...
I am using the following select case statement:
Public Function adjgd(grade As Single)
Select Case grade
Case Is <= 0.0249
adjgd = 0
Case 0.025 To 0.0749
adjgd = 1
Case 0.075 To 0.1249
adjgd = 2
Case Is 0.1249
adjgd = 3
Case Else
adjgd = 0
End Select
End Function

. Anyone able to help?

Thanks in advance







--
M.R. Vanatta