Ask or Formula for random number with weighted and with out table explanation

[Karsonchu]

Hi. I would like to ask how can I generate a the cell output to be 1 with probability 20% and to be 2 with probability 80% only by using pure formula in excel? Thankssss

 

[Karsonchu]

Hi. I would like to ask how can I generate a the cell output to be 1 with probability 20% and to be 2 with probability 80% only by using pure formula in excel? Thankssss

Question: What is the formula in Excel if we want a cell's output to be 1 with a probability 0.2, and to be 2 with a probability 0.8?

 

[Rick Rothstein]

This should work...

=MID("1122222222",RANDBETWEEN(1,10),1)

 

[joeu2004]

What is the formula in Excel if we want a cell's output to be 1 with a probability 0.2, and to be 2 with a probability 0.8?

=IF(RAND()<0.2, 1, 2)