Finding a "Between" function

  • Thread starter Thread starter Lifesaver197
  • Start date Start date
L

Lifesaver197

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(C2>2,"Watch your attendance! Remember, you are only allowed 6
absents!!", IF(C2>4,"Your attendance is excessive! Remember, you are
only allowed 6 absents.",IF(C2>6, "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."
 
Try this:

=IF(AND(C2>1,C2<4),"Watch your attendance! Remember, you are only allowed 6 absents!!", IF(AND(C2>3,C2<6),"Your attendance is
excessive! Remember, you are only allowed 6 absents.",IF(C2>5, "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
 
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(C2>1,C2<4),"Watch your attendance! Remember, you are only allowed 6 absents!!", IF(AND(C2>3,C2<6),"Your attendance is
excessive! Remember, you are only allowed 6 absents.",IF(C2>5, "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
 
Conan Kelly said:
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
Click to expand...

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Conan Kelly,
You were right on. It works great!! I thank you, but my students might
dislike you for helping me be more accurate. ;-)
 
Back
Top