OpenOffice3.org Calc 3. Mathematical Functions
RANDBETWEEN(Bottom;Top) Function
Returns a random integer, wich is within
the range of values indicated by the arguments of the function. The argument
“Bottom” contains a numeric value indicates the lower limit within which it must
be the random number. The argument “Top” contains a numeric value indicates the
upper limit within which it must be the random number. The argument “Bottom”
should be less than the argument “Top”, otherwise, the function returns error.
For example:
=RANDBETWEEN(24;40) Returns 27. When recalculated, the function returns a
different value.