|
I do a similar, but more complex setup for my student's grades.
The command that is your friend is VLOOKUP().
The function will go to a 2-column table, lookup the value in the first column, and return the value in the second column.
So if you make a table:
|letter | value
---------------
A | 4
B | 3
and so on, it will work.
Granted, for only 4 values the if statement is probably faster/easier. But when you're dealing with more complex grade setups (A, A+, A-, B+, etc down to F) the lookup table is a life-saver.
|