Inline array constants in formulas

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.


Table 1. Examples of inline arrays
Array Description

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.

Trademarks | IBM Connections wiki