Menu
EXCEL RANDBETWEEN FUNCTION
Excel RANDBETWEEN Function Introduction
This function generates a random integer between two input values.
Description of Excel RANDBETWEEN Function
Syntax:
=RANDBETWEEN (bottom, top)
Parameter list:
- bottom – an integer that represents the range’s lower value.
- top – an integer that represents the range’s lowest value.
Step By Step Guide of RANDBETWEEN Function
For example, the number 38 may be generated using =RANDBETWEEN(1,50). Each time the worksheet is calculated, RANDBETWEEN generates a new value.
Key Points
Copy the cells that contain RANDBETWEEN and paste them as values using paste special to prevent random numbers from being changed. Select the cells, input the RANDBETWEEN function, then press Control + Enter to produce a set of random integers in several cells.
Enter RANDBETWEEN in the formulae bar to generate a random number that doesn’t change while the worksheet is computed, then press F9 to transform the formula into its result.
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
