Share via

School grades spreadsheet

Anonymous
2021-11-23T20:55:58+00:00

Most of us in school have a spreadsheet with all our scores to help us optimize our scores in school. this formula for excel can help that, all you need to use it is to designate a cell using define name and use the formula in the sheet anywhere. This formula will show your letter grade.

Formula:

=IF(AND(Grade>=93,Grade<=101),"A",IF(AND(Grade>=90,Grade<=93),"A-",IF(AND(Grade>=87,Grade<=90),"B+",IF(AND(Grade>=83,Grade<=87),"B",IF(AND(Grade>=80,Grade<=83),"B-",IF(AND(Grade>=77,Grade<=80),"C+",IF(AND(Grade>=73,Grade<=77),"C",IF(AND(Grade>=70,Grade<=73),"C-",IF(AND(Grade>=67,Grade<=70),"D+",IF(AND(Grade>=67,Grade<=70),"D",IF(AND(Grade>=60,Grade<=67),"D-",IF(AND(Grade>=0,Grade<=59),"F", IF(Grade>=100, "****, how did you get more than 100%, extra credit!?!?!?!","What the hell are you doing?!?!?!?!")))))))))))))

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-23T21:43:55+00:00

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments