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.


=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

Learn MS Excel

Ask Questions

Ask Question