How to Assign Letter Grades in Excel #shorts (forget IF function)
Calculating and assigning letter grades to students based on their achieved score is a common task. I'll show you how a super simple solution in Microsoft Excel to automate this task. Forget the Excel IF function for this. Instead use Excel VLOOKUP function. If you have office 365, you can use the XLOOKUP function as well.