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

Name	Type	Description
Min	Number	Minimum value to return.
Max	Number	Maximum value to return.
MinDelta (optional)	Number	Minimum 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)	Number	Maximum value applied to last value in next step. If specified MinDelta must also be set.
InitialValue (optional)	Number	Initial value to start with. Only used if MinDelta and MaxDelta are given. Note: delta will be applied to initial value.

Return

Type	Description
Number	Random number between minimum and maximum argument.

Examples

Formula	Result	Comment
=RANDBETWEEN(1, 10)	e.g.: 5	The return value can be any number between 1 and 10.
=RANDBETWEEN(10, 30, -1, 1, 15)	e.g.: 16	Initial 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.: 16	Initial value is 15 to which a random delta of 1, 2 or 3 is added. 1 in this case resulting in 16.