ARRAY ​

Creates an array from a list of values. This function is intended for use with other functions that require array-type inputs, such as IRR and XIRR.

ARRAY(...element)

ARRAY(...element)

Parameters ​

• element - Element in array

Examples ​

ARRAY(1, 2, 3, 4, 5)

ARRAY(1, 2, 3, 4, 5)

Result: [1, 2, 3, 4, 5]

Note: This will return an array containing the numbers 1, 2, 3, 4, and 5, which can be used as input for functions like IRR and XIRR.