Excel Formulas: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immed...") |
m (Chris moved page Excel Forumulas to Excel Formulas: Typo) |
(No difference)
| |
Revision as of 21:26, 31 May 2017
Here is a formula for converting a percentage to a letter grade. Here, the percentage score is in column Z (row 2), and this formula would be pasted into the cell to the immediate right (column AA):
=IF(Z2>=90,"A",IF(Z2>=85,"A-",IF(Z2>=80,"B+",IF(Z2>=75,"B",IF(Z2>=70,"B-",IF(Z2>=65,"C+",IF(Z2>=60,"C",IF(Z2>=55,"C-",IF(Z2>=50,"D","F")))))))))