RAND_BETWEEN

Returns a random number between the bottom and top values.

Function syntax

RAND_BETWEEN(bottom, top)

Arguments:

• bottom: The smallest value in the range.
• top: The largest value in the range.

Examples

• RAND_BETWEEN(1, 10) - Returns a random number between 1 and 10.
• RAND_BETWEEN(D1, E1) - Returns a random number between the values in cells D1 and E1.
• RAND_BETWEEN(number{!1}, number{!-1}) - Returns a random number between the first and last values in the number field.