By:
On:
In: Microsoft Office, Productivity, Teacher Tips, Windows

How to calculate or assign a letter grade in Excel? Here is the full article from ExtendOffice.com I ended up liking the 3rd option, using IFS (this only works in new versions of Microsoft 365) Here is the code: =IFS(H3>=94%,”A”,H3>=90%,”A-“,H3>=87%,”B+”,H3>=83%,”B”,H3>=80%,”B-“,H3>=77%,”C+”,H3>=73%,”C”,H3>=70%,”C-“,H3>=67%,”D+”,H3>=63%,”D”,H3>=60%,”D-“,H3Continue Reading