Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Numbers
In cells A1:A4 reside the following
20% 30% 40% 50% I have a block of records elsewhere. I need to drill through the last column of that block, randomly assigning one of those percentages. I can do the looping. I dont know if theres a formula I can use in the sheet to randomly draw from those percentages or if I have to incorporate code into a loop then assigning one of those presets. Im looking through a hardcopy of Excel formals and msdn, but have not found the direction I need. Direction welcome as to how I can put this together. Appreciatively, Arturo |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Numbers
This seems to do this
=(INT(RAND()*4)+2)/10 Regards, KL "Arturo" wrote in message ... In cells A1:A4 reside the following 20% 30% 40% 50% I have a block of records elsewhere. I need to drill through the last column of that block, randomly assigning one of those percentages. I can do the looping. I don't know if there's a formula I can use in the sheet to randomly draw from those percentages or if I have to incorporate code into a loop then assigning one of those presets. I'm looking through a hardcopy of Excel formals and msdn, but have not found the direction I need. Direction welcome as to how I can put this together. Appreciatively, Arturo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random Numbers excluding Previous Numbers | Excel Worksheet Functions | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) |