software

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(C2gt;2,quot;Watch your attendance! Remember, you are only allowed 6
absents!!quot;, IF(C2gt;4,quot;Your attendance is excessive! Remember, you are
only allowed 6 absents.quot;,IF(C2gt;6, quot;You have EXCEEDED the allowable 6
absents for the Program and are therefore EXPELLED from the
Coursequot;,quot;Very good attendance! Try to keep it that way.quot;)))

If working properly it should create:

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

=IF(AND(C2gt;1,C2lt;4),quot;Watch your attendance! Remember, you are only allowed 6 absents!!quot;, IF(AND(C2gt;3,C2lt;6),quot;Your attendance is
excessive! Remember, you are only allowed 6 absents.quot;,IF(C2gt;5, quot;You have EXCEEDED the allowable 6 absents for the Program and are
therefore EXPELLED from the Coursequot;,quot;Very good attendance! Try to keep it that way.quot;)))HTH

Conan
quot;Lifesaver197quot; gt; wrote in message oups.com...
gt;I created the following formula for updating my student on there
gt; attendance. I want Excel to create a phrase when the student's
gt; attendance falls within certain criteria. Does anyone have a suggestion
gt; on how I can get the phrases to create when the attendnce number falls
gt; within certain numbers? Here is the formula:
gt;
gt; =IF(C2gt;2,quot;Watch your attendance! Remember, you are only allowed 6
gt; absents!!quot;, IF(C2gt;4,quot;Your attendance is excessive! Remember, you are
gt; only allowed 6 absents.quot;,IF(C2gt;6, quot;You have EXCEEDED the allowable 6
gt; absents for the Program and are therefore EXPELLED from the
gt; Coursequot;,quot;Very good attendance! Try to keep it that way.quot;)))
gt;
gt; If working properly it should create:
gt;
gt; Absents:
gt; 0-1: quot;Very good attendance! Try to keep it that way.quot;
gt; 2-3: quot;Watch your attendance! Remember, you are only allowed 6
gt; absents!!quot;
gt; 4-5: quot;Your attendance is excessive! Remember, you are only allowed 6
gt; absents.quot;
gt;gt;6: quot;You have EXCEEDED the allowable 6 absents for the Program and are therefore EXPELLED from the Coursequot;
gt;
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(C2gt;1,C2lt;4),quot;Watch your attendance! Remember, you are only allowed 6 absents!!quot;, IF(AND(C2gt;3,C2lt;6),quot;Your attendance is
excessive! Remember, you are only allowed 6 absents.quot;,IF(C2gt;5, quot;You have EXCEEDED the allowable 6 absents for the Program and are
therefore EXPELLED from the Coursequot;,quot;Very good attendance! Try to keep it that way.quot;)))HTH

Conan
quot;Lifesaver197quot; gt; wrote in message oups.com...
gt;I created the following formula for updating my student on there
gt; attendance. I want Excel to create a phrase when the student's
gt; attendance falls within certain criteria. Does anyone have a suggestion
gt; on how I can get the phrases to create when the attendnce number falls
gt; within certain numbers? Here is the formula:
gt;
gt; =IF(C2gt;2,quot;Watch your attendance! Remember, you are only allowed 6
gt; absents!!quot;, IF(C2gt;4,quot;Your attendance is excessive! Remember, you are
gt; only allowed 6 absents.quot;,IF(C2gt;6, quot;You have EXCEEDED the allowable 6
gt; absents for the Program and are therefore EXPELLED from the
gt; Coursequot;,quot;Very good attendance! Try to keep it that way.quot;)))
gt;
gt; If working properly it should create:
gt;
gt; Absents:
gt; 0-1: quot;Very good attendance! Try to keep it that way.quot;
gt; 2-3: quot;Watch your attendance! Remember, you are only allowed 6
gt; absents!!quot;
gt; 4-5: quot;Your attendance is excessive! Remember, you are only allowed 6
gt; absents.quot;
gt;gt;6: quot;You have EXCEEDED the allowable 6 absents for the Program and are therefore EXPELLED from the Coursequot;
gt;

quot;Conan Kellyquot; lt;CTBarbarin at msn dot comgt; wrote in message
...
gt; Please forgive me if this shows up twice. I've already tryied to post
gt; 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
Conan Kelly,
You were right on. It works great!! I thank you, but my students might
dislike you for helping me be more accurate. ;-)