This is a new function introduced for Microsoft 365 subscribers. The Excel function is more versatile than the RAND or RANDBETWEEN functions. In addition to calculating numbers, the function can pull in random names from an Excel named range.
The function has 5 arguments, but they are all optional.
Argument | Description |
---|---|
Rows | The number of rows to return. |
Columns | The number of columns to return. |
Min | The minimum number of results. |
Max | The maximum number of results. |
Integer | True / False flag. True would return an integer. |