RANDBETWEEN()

Random integer from range

Returns a randomly-chosen integer (Number value) that falls within the specified lower and upper bounds.

Examples

RANDBETWEEN(1, 10) returns a random whole number between 1 and 10.

(RANDBETWEEN(0, 1) = 1) returns a random Yes/No value.

(RANDBETWEEN(0, 100) / 100.0) returns a random Decimal value between 0.00 and 1.00 with two digits after the decimal point.

INDEX({"Heads", "Tails"}, RANDBETWEEN(1, 2)) returns Heads or Tails as a Text value.  See also: INDEX()

MID("ABCDE", RANDBETWEEN(1, 5), 1) returns a random letter from A to E as a Text value. See also: MID()

INDEX(Students[Name], RANDBETWEEN(1, COUNT(Students[Name]))) returns a randomly-chosen student's name. See also: COUNT()

ORDERBY(Cards[Card ID], RANDBETWEEN(1, 52)) returns the list of Card ID column values in a random order. See also: ORDERBY()

Syntax

RANDBETWEEN(lower-bound, upper-bound)

  • lower-bound - Any numeric type that specifies the lowest random value that may be returned.
  • upper-bound - Any numeric type that specifies the highest random value that may be returned.

See also

UNIQUEID()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false