Site icon ExcelNotes

How to Use RANDBETWEEN Function

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.

Download: RANDBETWEEN Function

Exit mobile version