Related Function:

The RAND function returns an evenly distributed random real number greater than or equal to 0 and less than 1.

Syntax

=RAND()

Note: RAND takes no arguments but requires empty parentheses.

  • A new random real number is returned every time the worksheet is calculated.
  • If you want to use RAND to generate a random number but don’t want the numbers to change every time the cell is calculated, enter =RAND() in the formula bar, and then press F9 to change the formula to a random number.

Examples

  A B C
1 Formula Result Notes
2 =RAND() varies A random number ≥ 0 and less than 1
3 =RAND()*100 varies A random number ≥ 0 and less than 100
4 =RAND()*10+10 varies A random number ≥ 10 and less than 20
5 =RAND()*(20-10)+10 varies Same formula as in A4 but written as RAND()*(b-a)+a

Note: Although the number generated is between 0 and 1, you can use the function to generate a random real number between any two supplied limits a and b, using the formula:

=RAND()*(b-a)+a