Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello €“
I pick up a percentage from a given cell and based on some preset variance, say +/-10%, I need to randomly assign a new percentage to a block of cells elsewhere, based on that drivers range. So if the driver is 30% and the variance is +/-10% the range to randomly be applied to a block of cells elsewhere would be between 27%, 28%, 29%... to 33%. Each cell in that block getting a random number from that range. I have most of the looping components down; I just keep tripping over the above scenario and am not finding the pieces to put together. Any direction is greatly appreciated. Sincerely, Arturo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Randomizing | Excel Discussion (Misc queries) | |||
Is there a simple way to do a randomizing sort? | Excel Discussion (Misc queries) | |||
checkbox hell | Excel Programming | |||
ComboBox Hell!!! | Excel Programming | |||
Excel ADO.Net Hell :S | Excel Programming |