Adding 2 cells only if one is not over
 

I am trying to create an Attendance Calendar. We are allotted only a certain
number of days (can't go over that). But we get a day each month. I need
the formula to add Allotted Days + Carry over days and minus Total days used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao

Adding 2 cells only if one is not over
 

Look in the help index for

MIN & MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"srctr" wrote in message
...
I am trying to create an Attendance Calendar. We are allotted only a
certain
number of days (can't go over that). But we get a day each month. I need
the formula to add Allotted Days + Carry over days and minus Total days
used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never
to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao

Adding 2 cells only if one is not over
 

Substitute your cell references as necessary, and use a formula like
this:

=MIN(Allotted Days + Carry Over Days -Total days used,36)

If the first part of this exceeds 36, then 36 will be returned.

Hope this helps.

Pete

On Jan 12, 7:08*pm, srctr wrote:
I am trying to create an Attendance Calendar. *We are allotted only a certain
number of days (can't go over that). *But we get a day each month. *I need
the formula to add Allotted Days + Carry over days and minus Total days used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao

Adding 2 cells only if one is not over
 

Thanks for your help. I found an example that had me use MIN this way and it
works. =MIN(36,SUM(A8+B8-AI8))
--
cao


"Pete_UK" wrote:

Substitute your cell references as necessary, and use a formula like
this:

=MIN(Allotted Days + Carry Over Days -Total days used,36)

If the first part of this exceeds 36, then 36 will be returned.

Hope this helps.

Pete

On Jan 12, 7:08 pm, srctr wrote:
I am trying to create an Attendance Calendar. We are allotted only a certain
number of days (can't go over that). But we get a day each month. I need
the formula to add Allotted Days + Carry over days and minus Total days used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao

Adding 2 cells only if one is not over
 

That's fine, although you don't really need the SUM:

=MIN(36,A8+B8-AI8)

Thanks for feeding back.

Pete

On Jan 13, 12:57*pm, srctr wrote:
Thanks for your help. *I found an example that had me use MIN this way and it
works. *=MIN(36,SUM(A8+B8-AI8))
--
cao



"Pete_UK" wrote:
Substitute your cell references as necessary, and use a formula like
this:

=MIN(Allotted Days + Carry Over Days -Total days used,36)

If the first part of this exceeds 36, then 36 will be returned.

Hope this helps.

Pete

On Jan 12, 7:08 pm, srctr wrote:
I am trying to create an Attendance Calendar. *We are allotted only a certain
number of days (can't go over that). *But we get a day each month. *I need
the formula to add Allotted Days + Carry over days and minus Total days used
that month but never go over 36 days.

Allotted Days + Carry Over Days -Total days used = Total Days left (never to
exceed 36 days)

Thanks in advance for any help with this problem.

--
cao- Hide quoted text -

- Show quoted text -