Hi guys,
I'm trying to create a quick GPA calculator.
What I would like to do is create a custom function that assigns the following without changing the letter grade value I input into column J:
A = 4
B = 3
C = 2
The result should be when I input the formula into L3 to calculate grade points should be J3 * K3 and the result should be 16
I really don't want to use any lookup table function as I think creating a custom function would be much simpler and cleaner, but I am open to suggestions.
I'm trying to create a quick GPA calculator.
What I would like to do is create a custom function that assigns the following without changing the letter grade value I input into column J:
A = 4
B = 3
C = 2
The result should be when I input the formula into L3 to calculate grade points should be J3 * K3 and the result should be 16
I really don't want to use any lookup table function as I think creating a custom function would be much simpler and cleaner, but I am open to suggestions.