Greater Than, If Cell equals specific number.

[Wskip49]

Here is my problem. I have students Kg-5th Gr. I need to identify the ones over-aged when I enter the information. The following is what I'm trying to use but I get Y1 for ever cell. I need it to Identify the student as Y1 for One year overage and Y2 for tow years overage.

=IF(AND(Q35=$AL$3,O35>$AO$3),"Y1",IF(AND(Q35=$AL$3,O35>$AT$3),"Y2",""))

Q35=Gr. Level, O35=Age, AL3=Y1 AT3=Y2

I hope this makes sense.

[zbor]

Firste enter second criteria, then first

[Wskip49]

Thanks, Works Great. It seems easy when you have people that can make sense out of your mess.

[zbor]

Weeeeeell, think a little bit and you figure it for yourself why it's working

At last, you made most of the job