## Examples

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

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

`(RANDBETWEEN(0, 100) / 100.0)` gives 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 )

## Arguments

• lower-bound (any numeric type): the lowest random value that may be returned.

• upper-bound (any numeric type): the highest random value that may be returned.

## Return Value

A Number value: a randomly-chosen integer no less than lower-bound and no greater than upper-bound.