IBM Docs supports inline matrix or array constants in formulas.
An inline array is surrounded by curly braces, for example {' and '}. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE), or a literal string. Non-constant expressions are not allowed. Arrays can be entered with one or more rows, and one or more columns. All rows must consist of the same number of elements; all columns must consist of the same number of elements.
The column separator (separating elements in one row) is the comma ( ,). This separator is not language and locale dependent.
Arrays cannot be nested.
Array | Description |
---|---|
={1,2,3} | An array with one row consisting of the three numbers 1, 2, and 3. |
=SIN({1,2,3}) | Entered as a matrix formula, delivers the result of three SIN calculations with the arguments 1, 2, and 3. |