Text to grade conversion

2 years 8 months ago - 2 years 8 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: 2 years 8 months ago by brettm.

Please Log in or Create an account to join the conversation.