Article updated on January 31, 2018

Returns a random whole number between the numbers you specify.

This function is volatile meaning a new random number is created every time the worksheet is calculated.

Formula in cell D3:

=RANDBETWEEN(B3,C3)

Excel Function Syntax

RANDBETWEEN(bottom, top)

Arguments

bottom Required. The start number of the range you want to create a random number from.
top Required. The end number of the range you want to create a random number from.

Comments

Press F9 to calculate new random numbers. Use this function with care, it may slow down your workbook considerably if used extensively. This is the case with all volatile functions.