Excel Functions
RAND
Excel RAND Function
To create random numbers, using the RAND function.
The typeface is =RAND.
Any random number can be produced with Rand.
Limits can be specified, random data sets can be created, and much more.
To utilize the RAND function by default, type:
=RAND()
To use the RAND function to receive a random number up to a certain value, write:
=RAND()*value
To use the RAND function to receive a whole number, write:
=INT(RAND())
How to Use RAND Function
To receive a random number, use RAND.
Step 1) Start the RAND function
- Select a cell A1
- Type =RAND
- Double click the RAND command
Step 2) Close the function
- Close the function with ())
- Hit enter
The random number has been generated!
How to Use RAND Function With a Defined Limit Value.
- Define the limit (*10)
- Hit enter
A random number between 0 and 10 has been generated!
How to Receive a Whole Number Using The RAND Function.
- Add (INT) before the RAND function
- Hit enter
A full number at random from 0 to 10 has been produced!
How to Generate Multiple Random Numbers.
- To produce more numbers, drag the cell’s lower right corner downward.
The A column produced ten randomly generated numbers!
