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

aandb, using the formula:=RAND()*(b-a)+a