This will produce a random decimal number between 0 and 1. If you need a random number within a specific range, you can scale it by multiplying the RAND function with the upper limit of the range.

From jury duty to tax audits, randomness plays a big role. Scientists used quantum physics to build a system that ensures those number draws can’t be gamed.

RANDARRAY() will return 0 or 1 respectively, if you omit min and max. The min argument must be less than max. RANDARRAY() will include decimal values if you don’t explicitly set integer to TRUE.

Many random-number generators are intended effectively to generate a series of 1's and 0's just like a series of coin tosses. On average, the two digits should each appear with 50% probability.

[Giorgio] also performed an interesting Monte Carlo simulation with his megabytes of random data: By plotting points on a plane (with a range from 0,0 to 1,1), [Giorgio] can approximate the value ...