Menu
EXCEL RAND FUNCTION
Excel RAND Function Introduction
There is no input for this function, and it returns a random integer between 0 and 1. Each time the page is refreshed or the function is called, new values are generated.
Description of Excel RAND Function
Syntax:
=RAND()
Use the following formula to create a random integer between a and b: (b-a)+a RAND().
Step By Step Guide of RAND Function
You must copy the cell and paste it as values using paste special if you do not want the random numbers to be produced.
Key Points
- Alternatively, put =RAND() in the equations bar and then press F9 to transform the formula into its result if you want a random integer that doesn’t change when the worksheet is generated.
- Select the cells, type RAND(), and press Control + enter to produce a set of random integers in several cells.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
