I am trying to have Excel automatically put in numbers for me relating to
grades. Our grading system follows:

Grade Min % Points
A+ 100 12
A 95-99 11
A- 93-94 10
B+ 91-92 9
B 87-90 8
B- 85-86 7
C+ 83-84 6
C 79-82 5
C- 77-78 4
D+ 75-76 3
D 72-74 2
D- 70-71 1
F 0-69 0

I have a column that I input a student's grade percentage by subject. The
next column I want to create a formula that will choose the student's
percentage (in previous column) and from that percentage input the point that
accurately goes with the percentage grade. For example, if a student has
96.77 in Math, I want to create a formula that will look for the point that
goes with 96.77, which would be 11. Do I need to, first, have the formula
set to round the percentage and then look up what point goes with that
percentage? What would the formula be that I use?

Thank you.