Teacher/Professor - Grading Calculation [confidential]
Can you work out two different formulae for calculating final grades for the Track II and non-Track II students?
SEE: Excel Worksheet
For this problem, you first need to make a Horizontal Lookup Table, which can convert letter grades to numbers. Then, you need to make an IF statement, so ...