XL.Random function

XL.Random function – Array function type – generates a set of random numbers. Supports the ability to generate a unique set of random numbers.

There are functions like RANDARRAY and RANDBETWEEN in Excel that can be used to generate an array of random numbers, but these functions have some limitations:

  • The standard functions are volatile, i.e. they change values each time you make changes in your spreadsheet
  • It is very hard to generate an array on unique random numbers using standard functions

XL.Random function helps avoid these limitations.

Syntax

=XL.Random(from, to, unique)

ArgumentDescription
from
[required]		The smallest integer that XL.Random will return.
to
[required]		The largest integer that XL.Random will return.
unique
[optional]		Return a whole number or a decimal value.
TRUE for a whole number.
FALSE for a decimal number.

Explore other functions

Any questions or suggestions?
How can we help?