NESTED IF FUNCTION HELP! TEACHER needs it to help students please!!!

[wildmountainrose]

I am not an expert but I can get around excel through trial and error and tutorials. Trying to create an if function to assess student data. I have a ruberic for student scores that I am trying to turn into an IF nested function or some other way to be able to take the score in one cell and turn it into the description in a seperate cell ex: Cell C1=14 Cell D1=Approaching standard so I can sort and group students. This is my ruberic....
Meeting Standard 19-25 points
Approaching Standard 13-18 points
Strategic 7-12 points
Intensive 6 points or less

this is the formula im trying :
=if(AND(A4>19,"Meeting Standard"),if (A4 <12 and A4<19,"approaching standard",if (A4>5 and A4<13,"strategic",if (A4<6,"intensive")))))

am I close? Anybody have any tips

 

[Rick Rothstein]

Try it like this...

=IF(A4<=6,"Intensive",IF(A4<=12,"Strategic",IF(A4<=18,"Approaching Standard",IF(A4<=25,"Meeting Standard","No description for that number"))))

 

[wildmountainrose]

It worked! thank you!