RAND formula in Excel and 10 Ways to Use It

The RAND is a function that would return with an equally distributed random number that is either greater than or equal to 0 and less than 1. The new random real number will be returned every time that it is being calculated.

The Syntax is RAND(), and there are no arguments for it.

Example 1: Standard RAND Formula

We would like to know the rand, which is why we are using the RAND function.

Standard RAND Formula


Example 2: Numbers and RAND

This is for finding out the even numbers with the rand function.

Numbers and RAND


Example 3: Evenly 100

This is for finding out the even numbers for 100, with the rand function.

Evenly 100


Example 4: RAND Function with Flexibilities

This is to try and find out the rand, since we have already layout different data.

RAND Function with Flexibilities


Example 5: SUMPRODUCT and RAND

We'd have different numbers that have been layout, and would like to know what it would mean for finding answers.



Example 6: SUM and RAND

The data is layout, and we would like to acknowledge the randomly generated number. This is to find out the even numbers.



Example 7: Double SUM and RAND

The data has been spread, and we would like to find out what the even numbers will be, and subtract 15 percent from the total number, in order to get the evenly generated number.

Double SUM and RAND

Example 8: Double SUM and Double RAND

The circumstances is we are examining how it would look for the even numbers when we are trying to find the answers that correspond with the data.

Double SUM and Double RAND


Example 9: AVERAGE and RAND

We are using the previous data to find the answer, with the average at its center. This is why we are using both AVERAGE and RAND formulas.



Example 10: Rand and Average

This time we'd have no data, but we have to find out the random and average functions working together to find the answers.

Rand and Average