LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Chad
 
Posts: n/a
Default Dividing a Total with criteria...

I am trying to write a formula that will figure out how many sections will go
into a number. The sections have to be between 10 and 20 feet each. For
example: If I have a 40 foot section, 2 20 foot sections will go evenly. If
I have a 50 foot section, 2 20 foot sections and 1 10 foot section.
Moreover, for a 25 foot section, it has to be 2 12.5 foot sections or 1 10
foot section and one 15 foot section, not 1 20 foot section and 1 5 foot
section, because all sections have to be between 10 and 20 feet.
So, each section has to be between 10 and 20 feet and I am trying to get as
few number of sections as possible.

Anyone have any idea how to accomplish something crazy like this with a
formula or even in multiple steps?
 
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
Can I get the mode, min, and max with multiple criteria? BobT Excel Discussion (Misc queries) 1 February 15th 05 03:20 AM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM
keep a running total of my formula results after each (F9) Souvien Excel Discussion (Misc queries) 1 January 23rd 05 01:59 AM
Total remaining formula jbsand1001 Excel Worksheet Functions 2 January 6th 05 04:17 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 05:13 AM.

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"