Hello,

I have to classify students by year in college. At the moment, next to their name is states their year but I need this to be display as a numeric value. I am attempting to nest IF functions to help me solve this task. As of now, my function looks like this....

=IF(M2=Freshman,1,IF(M2=Sophomore,2,IF(M2=Junior,3,IF(M2=Senior,4,0))))

This equation doesn't give me anything, not even an error. It simply displays in the cell as the written formula.

Can someone please help me proof this equation or create a new equation that would serve the same purpose?

Thanks in advance for your time!

Jon