Skip to content

Instantly share code, notes, and snippets.

@carlynorama

carlynorama/excel_formulas_for_grading.txt

Created May 8, 2014 15:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save carlynorama/92f44138fda5df56f051 to your computer and use it in GitHub Desktop.
Save carlynorama/92f44138fda5df56f051 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Formulas for Grading
Raw
excel_formulas_for_grading.txt
#for translating letter grades when the students number grade is in cell
#A9 and there are named cells (coA, coB, coC, coD) with the cutoffs
=IF($A$9>=coA,"A",IF($A$9>=coB,"B",IF($A$9>=coC,"C",IF($A$9>=coD,"D","F"))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment