Rand (Returns the rank of a number in a list of numbers for statistical Purpose)

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()

Formatting

No special formatting is needed.

Example

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.

The same technique has been used to generate a list of six winning lottery numbers.