Try this:

=IF(AND(C21,C2<4),"Watch your attendance! Remember, you are only allowed 6 absents!!", IF(AND(C23,C2<6),"Your attendance is
excessive! Remember, you are only allowed 6 absents.",IF(C25, "You have EXCEEDED the allowable 6 absents for the Program and are
therefore EXPELLED from the Course","Very good attendance! Try to keep it that way.")))


HTH

Conan



"Lifesaver197" wrote in message oups.com...
I created the following formula for updating my student on there
attendance. I want Excel to create a phrase when the student's
attendance falls within certain criteria. Does anyone have a suggestion
on how I can get the phrases to create when the attendnce number falls
within certain numbers? Here is the formula:

=IF(C22,"Watch your attendance! Remember, you are only allowed 6
absents!!", IF(C24,"Your attendance is excessive! Remember, you are
only allowed 6 absents.",IF(C26, "You have EXCEEDED the allowable 6
absents for the Program and are therefore EXPELLED from the
Course","Very good attendance! Try to keep it that way.")))

If working properly it should create:

Absents:
0-1: "Very good attendance! Try to keep it that way."
2-3: "Watch your attendance! Remember, you are only allowed 6
absents!!"
4-5: "Your attendance is excessive! Remember, you are only allowed 6
absents."
6: "You have EXCEEDED the allowable 6 absents for the Program and are therefore EXPELLED from the Course"