RANDBETWEEN Function in Excel generates a random integer between two given numbers (integers).
Syntax for RANDBETWEEN Function in Excel:
RANDBETWEEN(bottom, top)
- Where bottom is the lower limit for the random number to be generated
- Top is the upper limit for the random number to be generated
Example of RANDBETWEEN Function in Excel
Formula
RANDBETWEEN calculates a new value each time when the worksheet is updated, saved or refreshed.
Result
Note: #VALUE! Error occurs if the supplied arguments are non-numeric.
#NUM! Error occurs if the bottom argument is greater than the top argument.