RAND
What Does It Do ?
This function creates a random number >=0 but <1.
The number will change each time the worksheet recalculates, or when F9 is pressed.
Syntax
=RAND()
=RAND()
Formatting
No special formatting is needed.
No special formatting is needed.
Examples
The following examples show how the =RAND() function has been used to randomly
sort list of information.
The following examples show how the =RAND() function has been used to randomly
sort list of information.
A list of cards has been entered in column C, and =RAND() in column D.
By clicking inside the random numbers and then using Data, Sort or the Sort button
the cards will be shuffled.
By clicking inside the random numbers and then using Data, Sort or the Sort button
the cards will be shuffled.
The same technique has been used to generate a list of six winning lottery numbers.
