Microsoft Office Tutorials and References
In Depth Information
Figure 11.20. Harriet gets to draft first in this season ’ s fantasy football
Harriet gets to draft first in this season ’ s fantasy football
league, thanks to the
league, thanks to the RAND
You can also use this technique to select a random subset from a data set. If
your manager wants you to contact every 20th customer, you can select all
the customers where =RAND() is 0.05 or less.
Whereas =RAND() returns a random decimal, =RANDBETWEEN generates an in-
teger between two integers.
The RANDBETWEEN function returns a random integer between the numbers
you specify. A new random number is returned every time the worksheet is
calculated. This function takes the following arguments:
bottom — This is the smallest integer RANDBETWEEN can return.
top — This is the largest integer RANDBETWEEN can return.
To generate random numbers between 50 and 59, inclusive, you use
=RANDBETWEEN(50,59). RANDBETWEEN is easier to use than =RAND to
=INT(RAND()*10)+50 to generate this same range of data.
Even though RANDBETWEEN generates integers, you can use it to generate
sales prices or even letters. =RANDBETWEEN(5000,9900)/100 generates ran-
dom prices between $50.00 and $99.00.