How to combine results of several if clauses in one formula?

Hello,

I am making a grading spreadsheet for my students. The students will receive extra points based on the number of exercises the have done. The amount of these points will be based on these conditions:

-A student must do at least 60 exercises to pass (they are short ones and the course is long, this ain't a tight condition ). If this condition is not met, I want the excel to show how many he/she is lacking.
-If a student has done 80 exercises or more, he/she receives 1 extra point.
-If student has made 100 exercises or more, he/she receives 2 extra points.
-Additionally, the student who has done the greatest number of exercises gets 1 extra point more.

I have the following excel formula:

=IF(AA3>=100;2;IF(AA3>=80;1;IF(AA3>=60;0;(AA3-60))))+IF(AA3=MAX(AA3:AA22);1;0)

The first part is working nicely, but it doesn't do anything about the second part. Separately both if clauses function as they should, but I can't combine them.

Of course I could make 3 columns - 1st for the base point calculation, 2nd for max point calculation and 3rd where to calculate the sum (that's what I did now ). But for future it'd be nice to know if there is a convenient way to add the results of several if clauses together using a single formula.

Anyone have a nice and simple solution?

Well, now I feel like an a**. I just noticed that the latter part is not functioning even separately. I added $'s inside the MAX clause and now it's working like a charm. So, it seems to be ok to add results of IF clauses together in one formula.

Sorry, lack of sleep seems to have its effects. (And I still have 35 exams to grade before morning... )

I don't see anything wrong with the second part of your formula.