RANDBETWEEN Function

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

Learn MS Excel


Ask Questions

Ask Question