# Excel Tip: Find Random Integer Within a Selected Range

## default-16x9.jpg

Blogger
Tags
0

Excel's random number generating function, RAND, normally produces a random number that is a five- or six-digit decimal greater than or equal to 0 and less than 1. The function appears in your spreadsheet like this:

=RAND()

With a little customization, you can tailor this function to provide integers instead of decimals, and you can request the range within which the results should fall.

For example, if you want to find a random number between 1 and 500,000, the formula would look like this:

=INT(RAND()*(500000-1)+1)

A random number between 100 and 1,000 would be generated with this function:

## Trending

• ### Third Parties Used More for Internal Audit Work

=INT(RAND()*(1000-100)+100)

To find additional random numbers within the specified range, press the F9 function key and the random number function will recalculate.

Note that each time you recalculate or re-open a worksheet containing the random number function, the function will recalculate. Should you want to retain a random number that was generated with this function, enter the number without the function in a separate cell.