| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
How can one derive a random number from a specifc array, for example a random
selection from {2, 4, 16, 256, 65536} -- Best Regards, FARAZ A. QURESHI |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
On Fri, 8 Aug 2008 23:38:00 -0700, FARAZ QURESHI
wrote: How can one derive a random number from a specifc array, for example a random selection from {2, 4, 16, 256, 65536} Try this formula =CHOOSE(RANDBETWEEN(1,5),2,4,16,256,65536) Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
=INDEX({2,4,16,256,65536},RANDBETWEEN(1,5))
"FARAZ QURESHI" wrote: How can one derive a random number from a specifc array, for example a random selection from {2, 4, 16, 256, 65536} -- Best Regards, FARAZ A. QURESHI |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
=2^(2^INT(RND()*5))
Regards, Bernd |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
"Bernd P" wrote in message
... =2^(2^INT(RND()*5)) Clever, I like it! -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
RAND() / RANDBETWEEN() FOR SPECIFIC ARRAY
FARAZ QURESHI -
What is the probability for each of the five distinct values? Or, are the five values equally-likely? - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "FARAZ QURESHI" wrote in message ... How can one derive a random number from a specifc array, for example a random selection from {2, 4, 16, 256, 65536} -- Best Regards, FARAZ A. QURESHI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i set up rand or rand between to give only -1 or 1? | Excel Worksheet Functions | |||
| Text lookup array and match specific data | Excel Worksheet Functions | |||
| Array Formula returns error but only for specific columns | Excel Discussion (Misc queries) | |||
| How to return the row # of an expression in specific array of cell | Excel Worksheet Functions | |||
| How I can pick a specific value on an array in excel | Excel Discussion (Misc queries) | |||
Linear Mode
