Apple Numbers '08 - Manual (Page 264)

264 Chapter 12 Dictionary of Functions
RAND
The RAND function generates a random number greater than or equal to 0 and less
than 1.
RAND()
 No arguments (but you must include the parentheses).
Notes
Any time you change a value in the table, a new random number is generated.
RANDBETWEEN
The RANDBETWEEN function generates a random integer in the range of the specified
minimum and maximum.
RANDBETWEEN(min, max)
 min: The smallest number.
 max: The largest number.
Notes
Any time you change a value in the table, a new random number is generated.
RANK
The RANK function finds the rank of a number within a range of numbers. You can
choose to rank the numbers from largest down, or smallest up.
RANK(number, range, [order])
 number: The number whose rank you want to find.
 range: A reference to the range within which you want to rank number.
 order: Optional: specifies whether the smallest or the largest value in the range is
ranked 1.
0 (or omitted) ranks the number as if the largest value in the array has ranking 1.
Any other number ranks the number as if the smallest value in the array as ranking 1.
Examples
RAND() returns, for example, 0.67, 0.12, 0.8, and 0.9 after 4 recalculations.
Examples
RANDBETWEEN(1, 10) returns, for example, 7, 2, 9, 3, and 9 during subsequent recalculations.