As you can see my first try was wrong since I use 25 rather than .25. The integer divide would have worked with
=Choose( ((Val-1)*100)\25,"A","B","C","D","E"
And yes, values beyond 2.26 would have to be addressed with a longer expression such as
=IIf(Val>2.26,"E", Choose( ((Val-1)*100) \25, "A", "B","C","D","E"
My reply was a push in a direction and should have been more complete. In a similar thread I also suggested the Switch() function which is easier to maintain than multiple IIf()s.
Duane
MS Access MVP