Formulas and Functions

Chapter 8 Numeric Functions 189
RAND
The RAND function returns a random number that is greater than or equal to 0 and
less than 1.
RAND()
Usage Notes
The RAND function does not have any arguments. However, you must include the Â
parentheses: =RAND().
Any time you change a value in the table, a new random number greater than or Â
equal to 0 and less than 1 is generated.
Example
=RAND() returns, for example, 0.217538648284972, 0.6137690856, 0.0296026556752622, and
0.4684193600 for four recalculations.
Related Topics
For related functions and additional information, see:
“RANDBETWEEN” on page 189
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
RANDBETWEEN
The RANDBETWEEN function returns a random integer within the specied range.
RANDBETWEEN(lower, upper)
 lower: The lower limit or bound. lower is a number value.
 upper: The upper limit or bound. upper is a number value.
Usage Notes
Any time you change a value in the table, a new random number between the Â
lower and upper limits is generated.
Example
=RANDBETWEEN(1, 10) returns, for example, 8, 6, 2, 3, and 5 for ve recalculations.