RANDBETWEEN Function in Excel

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 Function in Excel 1

RANDBETWEEN calculates a new value each time when the worksheet is updated, saved or refreshed.

Result

RANDBETWEEN Function in Excel 2

Note: #VALUE! Error occurs if the supplied arguments are non-numeric.

           #NUM! Error occurs if the bottom argument is greater than the top argument.

previous-small RANDBETWEEN Function in Excel                                                                                                                next_small RANDBETWEEN Function in Excel