Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to create a formula or script that will accomplish the
following Lets say I'm going to sell 7 apples over the next 12 months I'm trying to create a script that will evenly distribute the 7 apple sales across the 12 months I cannot sell part of an apple so the numbers must be zero or one(this is what has me jammed up) The script will allow for more than one apple to be sold in a month if I were to reduce the months from 12 to 6. I would like a way to 'weight' the distribution having more sales occur at the beginning or the end of the time frame. Any suggestions would be greatly appreciated!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrap Text Evenly in Cell | Excel Discussion (Misc queries) | |||
two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
DIVIDE NUMBERS EVENLY | Excel Worksheet Functions | |||
Divide numbers and distribute evenly. | Excel Worksheet Functions | |||
Distribute values evenly in two columns | Excel Discussion (Misc queries) |