Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |