What is wrong with my nested IF statement?

[Simale]

I am tring to have people exter a number between 1 & 4 in a cell in column E and have this in the cells in column F to display the corsponding text that goes with the number they entered.

Excel keeps saying the function is wrong and I can't seem to be able to figure out what it is I am doing wrong.

Se below for my function:

=IF(E2>0,"New",IF(E2>1,"Beginner",IF(E2>2,"Experienced",IF(E2>3,"Veteran",IF(E2>4,"Choose a number between 1 and 4","Chose level between 1-4 to the left")))))

 

[Nishant94]

=LOOKUP(E2,{0,"New";1,"Beginner";2,"Experienced";3,"Veteran";4,"Choose a number between 1 and 4"})

 

[Yongle]

try this instead

=CHOOSE(E1,"New","Beginner","Experienced",Veteran)

 

[jmacleary]

You have the order of your IF statements wrong, so it will only ever give 'New'. Try this instead:

=IF(E2>4,"Choose a number between 1 and 4",IF(E2>3,"Veteran",IF(E2>2,"Experienced",IF(E2>1,"Beginner",IF(E2>0,"New","Choose level between 1-4 to the left")))))

John

 

[Yongle]

Just spotted that I missed your other condition ...
so ignore post3

=IF(AND(E2>0,E2<5),CHOOSE(E2,"New","Beginner","Experienced",Veteran),"Choose a level between 1-4 to the left")

 

[Simale]

Thank you all for trying to help me. I have tried them all and sadly none of them worked.
They all gave the same non-descriptive generic error message that something is wrong with my function just as with my original function.

I can't begin to figure out how come none of these worked.