RandBetween

Syntax

RandBetween(TopValue, BottomValue)

TopValue. The least number returned by the RandBetween function.

BottomValue. The greatest number returned by the RandBetween function.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

It returns a random number within an interval between two specified numbers.

A new random real number is returned during each sheet calculation.

Formula	Result	Description
=RandBetween(3.3, 6)	Changes.	A random number between 3.3 and 6.
=RandBetween(B6, C6)	Changes.	A random number between the numbers in the B6 and C6 cells. The B6 cell contains the -4 number, C6 contains 1.