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.
js
ARRAY(...element)Parameters
element- Element in array
Examples
js
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.