Finding a "Between" function
 

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"

Finding a "Between" function
 

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"

Finding a "Between" function
 

Please forgive me if this shows up twice. I've already tryied to post this once. OE shows that it was sent, but it hasn't shown up
yet.



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"

Finding a "Between" function
 

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
Please forgive me if this shows up twice. I've already tryied to post
this once. OE shows that it was sent, but it hasn't shown up yet

I see your first post but I do continue to see other posts replying to posts
that I cannot see. I have read in the NG's that this is caused but poor
synchronisation on the MS server.

--
Regards

Sandy

In Perth, the ancient capital of Scotland


with @tiscali.co.uk

Finding a "Between" function
 

Conan Kelly,
You were right on. It works great!! I thank you, but my students might
dislike you for helping me be more accurate. ;-)