Thread
:
simulations
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
simulations
You're Very welcome. Thanks for the feedback.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Notey" wrote in message
...
Thank you!
-Notey
"Sandy Mann" wrote:
You don't say how you want to have the die being unfair. This will give
a 6
for 50% of the time, 3 for 25% of the time and the other numbers for 8
1/3%
of the time:
=CHOOSE(INT(RAND()*12+1),1,2,3,3,3,4,5,6,6,6,6,6)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Notey" wrote in message
...
How do you simulate an unfair spinner or die?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann