Random Numbers in a Range

If you have the Analysis Tookpak loaded in your system, you have a powerful function that allows you to easily return a random integer number within a range. For instance, you can use the RANDBETWEEN function to return a random integer number between 50 and 99, or between -25 and 0. The syntax for the function is as follows:

=RANDBETWEEN(lower, upper)

All you need to do is provide the lower and upper values. If the first number you provide is actually higher than the second number, then RANDBETWEEN returns a #NUM! error.

The RANDBETWEEN function is a part of the Analysis Toolpak. If you get an error when you try to use the function, you can make sure the toolpak is loaded in this manner:

1. Choose Add-Ins from the Tools menu. Excel displays the Add-Ins dialog box. (Click here to see a related figure.)
2. Make sure the Analysis Toolpak check box is selected.
3. Click on OK.