Rand

The Excel RAND function generates a random number greater than or equal to 0 and less than 1. Whenever the spreadsheet is opened or edited, the value is recalculated.

Syntax

=RAND()

The Rand function does not need any arguments.

Example 1: Basic use of the Rand function

You can try out the Rand function using the editor below.

Spreadsheet editor

Explanation

The value in cell A1 is chosen randomly between 0 (including 0) and 1 (excluding 1). So the value will be something like 0.65691253052.

Example 2: Generate a number between two specific numbers

We can use the value generated from Rand to create a random value in any range we choose. For example, if we want a random number between 5 and 15, we can use =5 + (15-5) * RAND(). Like in the example below.

Spreadsheet editor

Explanation

To create an Excel formula that generates a random value in a range of your choosing, use the following formula:

For a value between x (inclusive) and y (exclusive):

=x + (y - x) * RAND()

Questions

How do I generate a random number that doesn’t change when editing the spreadsheet?

You can generate a number using RAND() like normal and then change it to a fixed value by pressing F9.

How do I generate a random number in a specific range?

Use the formula =x + (y - x) * RAND() for a number between x and y. See the example above to see this in action.

Drawbacks

  • Not often do you need a number that recalculates with every edit of the Excel sheet. Therefore, changing the random value to be exact (by using F9) is a good trick to learn.

Leave a Comment