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
Bookmarks