Excel Formulas: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
==Letter Grade Conversion== | ==Letter Grade Conversion== | ||
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): | Here is a formula for converting a percentage to a letter grade using the score breakdown at UWO. 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"))))))))) | =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"))))))))) | ||
Here's how the percentages convert to letter grades using the typical UB thresholds | |||
=IF(Z2>=94,"A",IF(Z2>=90,"A-",IF(Z2>=87,"B+",IF(Z2>=83,"B",IF(Z2>=80,"B-",IF(Z2>=77,"C+",IF(Z2>=73,"C",IF(Z2>=70,"C-",IF(Z2>=65,"D+",IF(Z2>=60,"D","F")))))))))) | |||
Latest revision as of 12:33, 21 December 2017
Letter Grade Conversion
Here is a formula for converting a percentage to a letter grade using the score breakdown at UWO. 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")))))))))
Here's how the percentages convert to letter grades using the typical UB thresholds
=IF(Z2>=94,"A",IF(Z2>=90,"A-",IF(Z2>=87,"B+",IF(Z2>=83,"B",IF(Z2>=80,"B-",IF(Z2>=77,"C+",IF(Z2>=73,"C",IF(Z2>=70,"C-",IF(Z2>=65,"D+",IF(Z2>=60,"D","F"))))))))))