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,
Brett
