Rational
Return random number within a range.
Description
The Excel RANDBETWEEN function generates a set of random integers between a lower bound (bottom) and an upper bound (top) number.
For example, =RANDBETWEEN(10,50) always returns a random integer between 10 and 50 (no decimal).
Syntax
=RANDBETWEEN (bottom, top)
Parameters
bottom – The low-end of value
top – The high-end of value
Return Value
A random integer between two given numbers
Key Notes
- The RANDBETWEEN function generates a number between two value (bottom and top). For example, =RANDBETWEEN(1.5,5.5) always returns a random integer between 2 and 5.
- RANDBETWEEN () is a volatile function, meaning each time a worksheet is recalculated or open, the random values change.
- To paste static value press & enter F9 key directly in the formula bar that converts a formula into a numeric literal.
Example
If user wish to insert random number with decimal format in a cell, like here we apply formula
=RANDBETWEEN(B8,C8)+RAND() it return 75.30.
Keep Reading Similar Functions:
ROUND
The ROUND function returns a number after rounding a supplied number to a specific number of digits like =ROUND(19.62159344,3) returns 19.621 (3 decimals).
RAND
The RAND function generates a number in the decimals format between 0 to 1, =RAND()*10+10 always returns a decimal number falling between 10 and 20.