complicated if

[cotix]

Hi guys, i have a problem and i need your help. I must create a formula that tells which grade(5,4,3,2,1) a student got for certain amount of points. Example: one student got 9 points out of 12 and formula must tell that he got 4. There are several values i that table, i only may use "if", and when that little black square is pulled down all values have to be right. Any help, please? thanks!

[4everGS]

If you indicate the rules in calculating the grades, you will surely receive help.

[cotix]

0-4 points 1
5,6 2
7,8 3
9,10 4
11,12 is 5.
can you just type a formula. i tried everything but i always get 1. appreciate your help

[cotix]

oh, base value, or whatever it's called is 9

[XOR LX]

Hi,

=IF(A1<5,1,(EVEN(A1)-2)/2)

Regards

[cotix]

the only point is that we haven't learned "even" so
there might be problem with my teacher. He sad
that there must be ifs inside ifs. It's only function i may use. so if you can show me that kind of formula if not problem.

[AlKey]

Here is with IFs

=IF(A1<=4,1,IF(A1<=6,2,IF(A1<=8,3,IF(A1<=10,4,IF(A1<=12,5,"")))))

[cotix]

With both formulas i get 1. Maybe i didn't explained well, so here is my file, and formula must be "universal", if my teacher pulls that little black square down, all rows must be correct. I know i'm boring but you are my only hope...

[cotix]

pardon me. Formula is correct, i inputted it wrong. Thank you guys for your help, helped me alot!