Monday, December 21, 2015

RAND function

This article describes the formula syntax and usage of the RAND function in Microsoft Excel.

Syntax: RAND()

Returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.


Note: When a worksheet is recalculated by entering a formula or data in a different cell, or by manually recalculating (press F9), a new random number is generated for any formula that uses the RAND function.

Download file

No comments :

Post a Comment