What is RAND?
Returns a random decimal number between 0 and 1. Recalculates with each worksheet change.
Syntax
=RAND()
Example
Formula: =RAND()
Result: Random 0-1
How It Works
Returns a random value like 0.7234... Changes every recalculation. For fixed random, copy and paste values.