Letter Grade Converter & Grade Calculator
Convert scores to grades, calculate averages & track attendance
Letter Grade Converter
Convert numeric scores to A/B/C/D/F
Quick Scenarios
Generated Formula
=IFS(B2>=90, "A", B2>=80, "B", B2>=70, "C", B2>=60, "D", TRUE, "F")ExcelGoogle SheetsCompatible
Grading Made Simple
Teachers spend way too much time on grade calculations. These formulas handle the repetitive work: converting scores to letters, calculating clean averages, and tracking attendance.
Standard US Grading Scale
| Score Range | Letter Grade | GPA Points |
|---|---|---|
| 90-100 | A | 4.0 |
| 80-89 | B | 3.0 |
| 70-79 | C | 2.0 |
| 60-69 | D | 1.0 |
| Below 60 | F | 0.0 |
Why IFS Beats Nested IFs
The old way of writing grade formulas used nested IFs that were impossible to read. IFS lets you write conditions in order, making it easy to adjust your grading scale.
💡 Pro tip: When calculating class averages, always exclude zeros (students who were absent). Otherwise, a few no-shows will tank your class average unfairly.