I have four columns of data that are grades.There is one grade in each column.
(i.e the grades can consist of the following
F - 1.5
PC - 3
P - 4
C - 5
D - 6
HD - 7)
I want a total column, that averages the 4 grades. (i.e if in one row I have P,C,D,C the answer I should get is 5. For some reason only half my lookup table works, I cannot get all the grades to convert to numerical format.
Thanks for help.
(i.e the grades can consist of the following
F - 1.5
PC - 3
P - 4
C - 5
D - 6
HD - 7)
I want a total column, that averages the 4 grades. (i.e if in one row I have P,C,D,C the answer I should get is 5. For some reason only half my lookup table works, I cannot get all the grades to convert to numerical format.
Thanks for help.