RAND function in Excel returns a random number between 0 and 1.
Math and trigonometry
Generate a random number between 0 and 1.
Number equivalent to the Smallest Number or Date
RAND function takes no arguments
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)
New Dynamic Array Functions in Excel