I am struggling to get this right and not sure if it is possible and what workaround there might be. I need to have my percentages converted to a letter grade in the grade awarded column in my subform.

The conversion is as follows:

98 – 100% A* 96 – 97.9% A 92 – 95.9% B 88 – 91.9% C 84 – 87.9% D 80 – 83.9% E