## 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 whole number no less than `lower-bound` and no greater than `upper-bound`.

`UNIQUEID()`