The RANDBETWEEN function is to return a random integer between the two numbers.
Formula:
=RANDBETWEEN(bottom, top)
Explanations:
– The bottom is required, which is the smallest integer.
– The top is required, which is the largest integer.
Cautions:
– A new random will appear every time the worksheet is calculated, or press "F9" to change the results.