Is it possible to give a Text value a Numerical value. I am trying to set up
a grade calculator. I set it up so I can plug in the values of each letter
grade like 4.0, 3.7 and so on. How could I make it so that instead of having
the 4.0 there I could input A and it would still do the correct calculation.
I tried using LOOKUP and stuff but that still just returned the numerical
value. Thanks