Excel Formulas

From CCN Wiki

Revision as of 13:35, 24 May 2017 by 38.95.246.48 (talk) (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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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")))))))))

Retrieved from "https://ccn-wiki.caset.buffalo.edu/index.php?title=Excel_Formulas&oldid=980"