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)
Argument | Description |
---|---|
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. |
Any questions or suggestions?