How to assign letter grades in Excel


About this tutorial:

Video duration: 8:58
Screencast for Bridgewater College EDUC 370 students about having Excel assign letter grades based on a grading scale.


  1. Thank you so very much! This presentation was highly useful to me for my university class. It's great you took the time to tell future teachers how to do something so essential and valuable to the occupation. Thanks!!!

  2. Joe, my grading system is set up just like yours on the bottom to the left — but when I put in the lookup formula for my final grade, my student whose average (by the way I only have one student) equals 65 for his final is showing up that his letter grade is an A.  Is there anyway of helping me to see what I'm doing wrong.  Thanks.


Please enter your comment!
Please enter your name here