Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding cells | Excel Discussion (Misc queries) | |||
Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
ADDING CELLS | Excel Discussion (Misc queries) | |||
Adding only cells with an X in it | Excel Discussion (Misc queries) | |||
Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) |