The RANDBETWEEN function generates random whole numbers between the two given numbers. Note: The random numbers get changed every time the worksheet is recalculated or when F9 is pressed.
Formula:
=RANDBETWEEN(Lower limit, Higher limit)
Video Tutorial:
Let us learn how to generate random whole numbers, using the RANDBETWEEN function, with the help of the below video