Microsoft Office Tutorials and References

In Depth Information

**Using RAND and RANDBETWEEN to Generate Random Numbers and Data**

Figure 11.19.

Figure 11.19.
The

The SUBTOTAL

SUBTOTAL function in cell E2 ignores rows hidden as the

function in cell E2 ignores rows hidden as the

result of a filter.

result of a filter.

Note

Although the function in
Figure 11.19
uses the function number 109, the

Subtotal command always ignores rows hidden as the result of a fil-

ter. =SUBTOTAL(9,E5:E5090) would return an identical result when the

rows are hidden through a filter, as in this case. If you have rows

hidden by the Hide command, you should use 109 to ignore the manually

hidden rows.

Using

Using
RAND

to Generate Random Numbers and Data

In a number of situations, you might want to generate random numbers. Excel

offers two functions to assist with this process: RAND and RANDBETWEEN.

RAND
and

and
RANDBETWEEN

RANDBETWEEN
to Generate Random Numbers and Data

Syntax

=RAND()

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 every time the

worksheet is calculated.