RAND Function


RAND function in Excel returns a random number between 0 and 1.

Function Type

Math and trigonometry


Generate a random number between 0 and 1.

Return value

Number equivalent to the Smallest Number or Date




RAND function takes no arguments

Example 1

Example 2


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.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel