RAND function

Category: Math and trigonometry
Introduced: Excel 2003

Summary

Returns a random number between 0 and 1

Syntax

RAND() The RAND function syntax has no arguments.

Example

=RAND()
=RAND()*100
=INT(RAND()*100)

Microsoft Support Page

https://support.microsoft.com/en-us/office/rand-function-4cbfa695-8869-4788-8d90-021ea9f5be73

Back to Functions