Excel Random Number Generator

Versions:	Excel 2010 and later
Description:	Simple Excel spreadsheet with formulas to generate random integers or decimals.

Excel Random Number Formulas

The above Excel Random Number Generator spreadsheet calculates random integers or random decimals.

The random integer generator uses the Excel Randbetween Function to calculate a random integer between two values.

The random decimal generator uses the Excel Rand Function. The formula used to calculate a random decimal between two values, A and B, is:

=RAND() * ( B - A ) + A

For further information on generating random numbers in Excel, see the Excel Random Number page.