Excel RAND Function

HomeExcel FunctionsExcel RAND Function (Example + Sample File)

What is EXCEL RAND FUNCTION

The Excel RAND Function is listed under Microsoft Excel's Maths Functions category. It returns a random number ranging from 0 to 1. In simple words, with RAND function, you can generate a random number between 0 to 1 (it updates its value every time you make a change in the worksheet).

How to use it

To learn how to use the RAND function in Excel, you need to understand its syntax and arguments: 

Syntax

RAND()

Arguments

  • there is no argument to specify in RAND functions

Notes

  • If you put zero in multiple it will return zero in the result.
  • If you skip specifying multiple it will return with an error.
  • It rounds away from zero.
  • If you have two multiples on the same distance it will return the multiple which is higher than the number you are rounding.

Example

To master the RAND function we need to try it out in an example and below is one which you can try out:

Apart from having numbers between 0 and 1, you can also use RAND for random numbers between two specific numbers.

In the below example, I have used it to create a formula that generates a random number between 50 and 100.

When you enter this formula in a cell it returns a number between 100 and 50 by multiplying the values returned by the RAND with the equation we have used.

To understand this formula we need to split it into three parts:

  1. First of all, when it detects the lowest number from the highest number you get the difference between both of them.
  2. Then secondly it multiplies that difference with the random number returned after the subtraction.
  3. And third, add that number with the lowest number left in the third part of the equation.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.