Improving/Consolidating a Long IF Formula

Hello,

I am using this in one of my fields:

=IF(M828=1,M828&"st Grade",(IF(M828=2,M828&"nd Grade",(IF(M828=3,M828&"rd Grade",(IF(M828="K","Kindergarten",(IF(M828="PreK","PreK",(IF(M828="PreS","PreSchool",(IF(M828="Tod","Toddler",M828&"th Grade")))))))))))))

This formula changes a field number like "1" to "1st Grade" and so forth.

I am certain there is a simpler way to do this, but not sure how. Any ideas?

Thanks in advance!

Welcome to the forum.

Please make your thread ttiles better in future - I have changed yours for you today.

You could use a LOOKUP or VLOOKUP formula.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

AS per Ali's solution:

=IFERROR(VLOOKUP($E1,$C$1:$D$7,2,0),$E1 & "th Grade")