Tutorial: Assign Letter Grades by Range with Index & Match
Using a simple 5-row table, you can assign letter grades based on criteria set in a table. The trick is, how do you assign a grade that may span a range of numbers (A "B" is 82 - 92 on the score). Do with this Match's "less than" match type. See how!
ZJAHLJIQOXAXIFSN
https://support.microsoft.com/en-us/o...