Having something happen randomly a given percentage of the time

[jrsimon25]

Hello. This is my first time posting. Hope I'm doing this right.

Is there a way to write a formula so that one outcome happens randomly a given percentage of the time and another outcome happens the rest of the time?

For example, I want the number 1 to appear 40% of the time and the number 2 to appear 60% of the time. Obviously this would be imbedded in a larger formula.

If this is possible, how do I do it?

Thank you

[bebo021999]

Try for first case:

Please Login or Register  to view this content.

Copy to next cell for second case.

It is so hard to test, because of value change continously, so you can change the % upto 80 or even 100% to test.

Clarafication:

With 40% in B2, 1 in B1, mean the last 19 number will be 60%.
The total of number now should be : ROUND((COUNT($A$3:$A$22)-1)/(1-B$2)=19/60%=32
with 23 of "1" and 19 of the rest
Now the RANDBETWEEN returns random number between 1 and 32
From 1-20 (occupy 60%): get random number in A3:A22
From 21-32 (occupy 40%): get number "1"

Hope it is clear enough for you.

[jrsimon25]

Thank you!