Microsoft Office Tutorials and References
In Depth Information
RAN The RAND function returns an evenly distributed random number greater than or equal to 0
and less than 1. A new random number is returned ever y time the worksheet is calculated.
The RAND function is a volatile function. This means that the value returned by that function is
changed each time the worksheet is recalculated. If the result of the RAND is to be stored, the
formula must be converted to its value. This can be accomplished by using Edit, Copy, then
Edit Paste Special and choosing the Values option from the dialog box, or by highlighting the
formula in the formula bar and pressing F9 and Enter.
Example: You can return a value between 0 and 2 with RAND()*2 . Notice the example in
Figure 10.20, the RAND function returns random numbers between point A and B:
=RAND()*(b-a)+a . (See also RANDBETWEEN in this chapter.)
The RAND function can
be used to create
random numbers between
two points as shown.
The RANDBETWEEN function returns a random integer between the integers you specify. A new
random number is returned ever y time the worksheet is calculated.
This function is available from the Analysis ToolPak under Tools, Add-Ins in the menu if the
box for that add-in is checked. If it is not in the add-in list, run Setup to install it. An example
is RANDBETWEEN(5,10) and can return 5, 6, 7, 8, 9, or 10.
The BOTTOM argument is the smallest integer RANDBETWEEN will
The TOP argument is the largest integer RANDBETWEEN will return.