| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto sum with Max Totals in Cells. Please help!
I need help! I'm working right now and I need the cells a certain way or i'm
in big trouble. I'm supposed to have it like this: Hours 11 regular 8 overtime 2 double t. 1 I need a formula that I just type in that 11 at the top first cell, and then it will auto sum into the other 3 cells underneath, but a maximum of 8 hours in the first cell, so then it will move on to 2 in the second cell but a maximum of 2 in the second cell, so all the other hours go to double time. Please help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Auto sum with Max Totals in Cells. Please help!
A1 11
A2 =MIN(A1,8) A3 =MIN(A1-A2,2) A4 =A1-(A2+A3) "Anthony A." wrote: I need help! I'm working right now and I need the cells a certain way or i'm in big trouble. I'm supposed to have it like this: Hours 11 regular 8 overtime 2 double t. 1 I need a formula that I just type in that 11 at the top first cell, and then it will auto sum into the other 3 cells underneath, but a maximum of 8 hours in the first cell, so then it will move on to 2 in the second cell but a maximum of 2 in the second cell, so all the other hours go to double time. Please help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Simple question - auto populate cells - dependent on other cell value. | Excel Discussion (Misc queries) | |||
| Can word wrap and merged cells auto row height properly in Excel | Excel Discussion (Misc queries) | |||
| Auto fill multiple cells depending on single cell value | Excel Worksheet Functions | |||
| re auto cloring of cells | Excel Worksheet Functions | |||
Linear Mode
