Assuming your score is in B2, formula is:

=IF(B2=90,"A",IF(B2=80,"B",IF(B2=70,"C",IF(B2= 60,"D","E"))))


"Chi" wrote:

Hi,

Would you please help me to write a formula to calculate grades?

Ex: 100 - 90 = A
89 - 80 = B
79 - 70 = C
69 - 60 = D
59 and below = F

Thank you
Chi