Here are some problems that our users have asked and received explanations on
GENERATE A LIST OF 20 UNIQUE RANDOM NUMBERS BETWEEN 1 AND 100.
Solved by D. H. in 29 mins
I need to generate two random numbers that cannot be equal. The number range is between 1 and 5. Currently I am using the Randbetween formula in two side by side cells. But I need advice on how to make sure they are never equal.
Solved by X. W. in 21 mins
I need to generate random values between two values. Every time I input this value, it generates to 1.000 =RANDBETWEEN(0.450,0.460)
Solved by I. J. in 18 mins
I am trying to generate random values between 0 to 1 with two decimal places in 31 rows such that my sum is a certain value. Need help to generate them.
Solved by O. C. in 18 mins
Problem 2: Suppose we are simulating a matchup between CO and NYY. We generate a random number between 0 and 1 and compare it to the win probability. If we randomly generate 0.45, is our conclusion that CO won or lost?