Skip to main content
Version: Streamsheets 3.0

RANDBETWEEN

Creates a random value between min and max. It is possible to create a series of increasing or decreasing values by specifying a delta range. The delta is randomly chosen within its range and applied to last returned value.

Syntax

=RANDBETWEEN(Min, Max, [MinDelta], [MaxDelta], [InitialValue])

Arguments

NameTypeDescription
MinNumberMinimum value to return.
MaxNumberMaximum value to return.
MinDelta (optional)NumberMinimum value applied to last value in next step. If specified MaxDelta must also be set. Min and MaxDelta together define the possible range of change
MaxDelta (optional)NumberMaximum value applied to last value in next step. If specified MinDelta must also be set.
InitialValue (optional)NumberInitial value to start with. Only used if MinDelta and MaxDelta are given. Note: delta will be applied to initial value.

Return

TypeDescription
NumberRandom number between minimum and maximum argument.

Examples

FormulaResultComment
=RANDBETWEEN(1, 10)
e.g.: 5The return value can be any number between 1 and 10.
=RANDBETWEEN(10, 30, -1, 1, 15)
e.g.: 16Initial value is 15 to which a random delta of -1, 0 or 1 is added. 1 in this case resulting in 16.
=RANDBETWEEN(10, 30, 1, 3, 15)
e.g.: 16Initial value is 15 to which a random delta of 1, 2 or 3 is added. 1 in this case resulting in 16.