RANDBETWEEN()
Syntax. RANDBETWEEN(bottom,top)
Definition. This function returns a random number from a range. A new random number is returned every time the worksheet is calculated.
Arguments
bottom (required) The smallest integer RANDBETWEEN() can return
top (required) The largest integer RANDBETWEEN() can return
Background. Random values are necessary in engineering and natural sciences to simulate processes.
To generate a random date, the value has to be a number.
Tip: Use RANDBETWEEN() to generate a random number
If you want to use RANDBETWEEN() to generate a random number but don’t want the numbers to change every time the cell is calculated, you can enter =RANDBETWEEN(bottom,top) in the formula bar and then press F9 to change the formula to a random ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.