How to convert a score to a letter grade
✓ Verified in LibreOffice 25.8.7.3Map numeric scores to A/B/C/D/F (or any tiered label) automatically.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F") | Excel 2019+. Older Excel: nested IFs, or the VLOOKUP approach in the explanation. |
| Google Sheets | =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F") | Identical. |
| LibreOffice Calc | =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F") | Identical. |
How it works
IFS checks the conditions in order and returns the first hit: 84 fails the ≥90 test but passes ≥80, so it's a B. The TRUE,"F" pair at the end is the catch-all — without it, scores below 60 return #N/A. For long or changing scales, a lookup table beats a formula: thresholds 0/60/70/80/90 in one column, letters in the next, then the closest-match lookup pattern (=VLOOKUP(A2,table,2,TRUE)) — edit the table, not the formula.
Verified, not just documented
We ran =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",A2>=60,"D",TRUE,"F") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned B — exactly the expected result. Every formula here is confirmed by actually executing it.