% Letter GP

90 - 100 A+ 10

85 - 89 A 9

80 - 84 A- 8

75 - 79 B+ 7

70 - 74 B 6

66 - 69 C+ 5

60 - 65 C 4

55 - 59 D+ 3

50 - 54 D 2

40 - 49 E 1

0 - 39 F 0

NOTE: My university is weird and uses a scale of 10. And I'll be replacing the GP value and putting the letter grade in another cell.

I created this formula:

=IF((AND(0<B8,B8<39)),0, IF((AND(40<B8,B8<49)),1, IF((AND(50<B8,B8<54)),2, IF((AND(55<B8,B8<59)),3, IF((AND(60<B8,B8<65)),4, IF((AND(66<B8,B8<69)),5, IF((AND(70<B8,B8<74)),6, IF((AND(75<B8,B8<79)),7, IF((AND(80<B8,B8<84)),8, IF((AND(85<B8,B8<89)),9, IF((AND(90<B8,B8<100)),10,"")))))))))))

B8 is highlighted blue, but it stops at IF((AND(75<B8,B8<79)) and it doesn't even show the 90-100 IF statement. It just cuts off.

Any idea?