The
RANDBETWEEN() function returns an evenly
distributed random integer number between
two specified values.
- The syntax for the function
is RANDBETWEEN (bottom, top).
The arguments "bottom"
and "top" must be numerical values
as recognized by excel.
The function RANDBETWEEN gernerates a random
number between the value "bottom" and the
value "top". For example: RANDBETWEEN(5,10)
= 7.
|
How
to use the RANDBETWEEN() function:
- Type " =RANDBETWEEN( "
- Enter
the coordinate of the first
data cell "A2"
- Type a colon.
- Enter
the coordinate of the last
data cell "B2"
- Type ")" then
press the "Enter" key.
|
|
|
|
Note: The
RANDBWETEEN function recalcualtes each
time the worksheet is refreshed.To force
the worksheet to refresh press the "F9"
key. |
