How to assign a number value to a letter

Forum|Forum|7 years ago
May 16, 2018
2 replies
874 views

I am trying to create a GPA calculator, so I want to assign a number value to letters. For ex. A=4, B=3, C=2, D=1, and F=0.

I will then multiple the credit hours by the letter. For ex. 3 x B = 9.

I understand how to do the calculations in the cells, but what I need help with is assigning a number value to the letters before completing a calculation.

Thanks.

This topic has been closed for replies.

G

gkaiseril

Inspiring

Using a drop down field for each course and using the Grade letter for the Item and assigning the weighting or number value to the Option would then cause the value of the drop down field to be the numeric value when the letter grade was selected. You can then use any of the filed calculation options to calculate the average.