Nurrrrthk -
=IF(RAND()<(2/3),0,1)
- Mike
http://www.MikeMiddleton.com
"nurrrthk" wrote in message
...
Hi,
I need to populate a test table with some random numbers.
Example : 0 or 1.
I fill in the table with "= Randbetween(0;1)" and that does the trick.
But now I need to bias the data so there is - for example -
twice a many chances of 0 than there is of 1.
How would I do that ?
TIA
Nurrrrthk