LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Auto sum with maximum value in a cell. 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell auto population - why 0 when source cell is empty? David Smithz Excel Discussion (Misc queries) 4 June 18th 06 05:35 PM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Can a cell have a drop down list and can also be auto populated Adrian Excel Worksheet Functions 1 March 17th 05 05:05 AM
Cell value as chart scale maximum Phil Hageman Charts and Charting in Excel 9 December 17th 04 02:09 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"