Auto sum with maximum value in a cell. Please help!

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto sum with Max Totals in Cells. Please help! 1
Calculating a Formula Subject to a Maximum and Minimum Value 2
Formulas--NEED HELP! 4
Calculating regular time, subtracting any personal time 5
formula to make the value in a cell, to a row in a sum function 5
formula for sum 3
Auto Change Formulas - Please Help. 2
Maximum Characters in a cell 1

Top