RANDARRAY
Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.
Math & TrigonometryMath BasicsModern Excel Functions
What it does
Generates an array of random numbers.
Syntax
RANDARRAY([rows], [columns], [min], [max], [whole_number])
Arguments
rows(number) — Number of rows.columns(number) — Number of cols.min(number) — Min value.max(number) — Max value.whole_number(logical) — TRUE for integers.
Examples
Random Integers
3 random ints 1-10.
FORMULA
=RANDARRAY(3, 1, 1, 10, TRUE)
RESULT
[3; 7; 1]
SAMPLE DATA
| A | |
|---|---|
| 1 | Rand |
| 2 | (Array) |