Generate Random Numbers using RANDBETWEEN function
Formula Syntax
=RANDBETWEEN(Bottom, Top)
Bottom represents the lower value of the range, and
Top represents the upper value of the range
The formula will generate random numbers between bottom and top. For example, =RANDBETWEEN(1000,9999) might generate the number 1777.
This formula will calculate a new value each time the worksheet is calculated. Therefore, it is suggested to copy the values generated by the formula and paste them as values.
Example
