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: 6
Default Formula to equal a maximum of 100%

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
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
Not More Than or Maximum in a formula Joel Excel Discussion (Misc queries) 1 July 15th 09 04:22 AM
Return Maximum from Column directly above Maximum in Row Code Numpty Charts and Charting in Excel 2 November 19th 08 07:29 AM
maximum formula excelguy[_2_] Excel Discussion (Misc queries) 2 September 25th 08 05:29 PM
What is the maximum formula lenght?? shirley_kee Excel Discussion (Misc queries) 3 May 4th 06 01:00 PM
Maximum of a formula Ralph Excel Worksheet Functions 6 July 6th 05 10:20 PM


All times are GMT +1. The time now is 03:31 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"