Text to grade conversion

3 years 3 months ago - 3 years 3 months ago #9728 by brettm
Text to grade conversion was created by brettm
I have a reading-level based on the Alphabet (Level A, B, C, etc up to Level Z.) - it is a Fountas and Pinnell reading level.

I would like to convert this to a text grade.

Can I do this without writing a long formula? (Formula would be: If cell=Level A, then Grade=E; If cell=Level C, then Grade=D; and so on ...)

My thanks,
Last edit: 3 years 3 months ago by brettm.