The Excel RANDBETWEEN function returns a random integer between two given numbers. RANDBETWEEN recalculates each time a worksheet is opened or changed.
Purpose:
Get a random integer between two values
Return value:
An integer/number
Syntax: =RANDBETWEEN (bottom, top)
Examples:
Below are basic examples of RANDBETWEEN formulas: =RANDBETWEEN(1,9) // random number between 1 and 9
=RANDBETWEEN(10,100) // random number between 10 and 100
=RANDBETWEEN(-10,0) // random number between -10 and zero
RANDBETWEEN recalculates whenever a worksheet is opened or changed.
RANDBETWEEN returns integers. Use the RAND function to return random decimal values.
3 thoughts on “Excel RANDBETWEEN function”