Thread: simulations
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default 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?