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"