New to the forum. I'm a CATE teacher and am working on a professionalism rubric that I can carry with me in the lab. I am getting stuck on this part. I would like to input one of 3 letters into a cell and have it correspond to a numerical value that a formula in another cell will see as that numerical value.

A layman's example would be: Y=100, P=75, n=50. I have this formula "=SUM(F2*0.25)+(((G2+H2)/2)*0.25)+(((J2+K2)/2)*0.25)+(((M2+N2)/2)*0.25)" in another cell that would need the numerical value of the letter in order for it to work.

I know my formula is somewhat amateurish but I'm a noob to all of this.

Thanks

John.