How to use the RANDBETWEEN function
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:
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.
Articles with the 'RANDBETWEEN' Function
The following 3 articles have formulas that contain the RANDBETWEEN function.
Functions in 'Math and trigonometry'
The RANDBETWEEN function function is one of many functions in the 'Math and trigonometry' category.