Remember Me?
Menu
Home
Search
Today's Posts
Home
Search
Today's Posts
ExcelBanter
»
Excel Newsgroups
»
Excel Worksheet Functions
>
simulations
LinkBack
Thread Tools
Search this Thread
Display Modes
Prev
Next
#
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
Thread Tools
Search this Thread
Show Printable Version
Search this Thread
:
Advanced Search
Display Modes
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Posting Rules
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Where can I download an Excel add-on to do MonteCarlo simulations
Stanitch
Excel Worksheet Functions
3
February 18th 05
01:47 AM
All times are GMT +1. The time now is
04:41 AM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
Contact Us
ExcelBanter forum home
Privacy Statement
LinkBack
LinkBack URL
About LinkBacks