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
Example 2
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)