Apple numbers User Manual

    Dictionary of Functions 

 

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.
  

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.
  

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.

RAND() returns, for example, 0.67, 0.12, 0.8, and 0.9 after 4 recalculations.

RANDBETWEEN(1, 10) returns, for example, 7, 2, 9, 3, and 9 during subsequent recalculations.