![](https://xlncad.com/wp-content/uploads/2020/07/RAND_1.png)
Table of Contents
About
RAND function in Excel returns a random number between 0 and 1.
Function Type
Math and trigonometry
Purpose
Generate a random number between 0 and 1.
Return value
Number equivalent to the Smallest Number or Date
Syntax
=RAND()
Arguments
RAND function takes no arguments
Example 1
![](https://xlncad.com/wp-content/uploads/2020/07/RAND_2.png)
Example 2
![](https://xlncad.com/wp-content/uploads/2020/07/RAND_3.png)
Notes
RAND function is a volatile function and update every time when a worksheet is recalculated or a workbook is opened.
RANDARRAY function is the updated version of RAND function.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)