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.

Examples

Table 1. Examples of inline arrays
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.



Trademarks | IBM Connections wiki