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

Create a table in A2:B6 that looks like this:

ColA..ColB
100....A
89......B
79.....C
69.....D
59.....F

Assuming your score to check is in A10, formula is:

=INDEX($B$2:$B$6,MATCH(A10,$A$2:$A$6,-1))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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

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