Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to put together some utilisation figures with a formula where the
answer can not exceed 100%. I.E if a vehicle can carry a max of 24 pallets per load then it's maximum utilisation is 100% per load but if the same vehicle does 2 trailer loads in a day with a combined total of 48 pallets then it's utilisation is still only 100% as it has taken 2 full traileirs or if the second load is only 12 pallets then the overall utilisation is only 75% (36 pallets delivered out of a maximum 48 possible) Can anyone please help, every way I try the answer is always over 100% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Not More Than or Maximum in a formula | Excel Discussion (Misc queries) | |||
Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
maximum formula | Excel Discussion (Misc queries) | |||
What is the maximum formula lenght?? | Excel Discussion (Misc queries) | |||
Maximum of a formula | Excel Worksheet Functions |