Inline array constants in formulas
IBM® Connections 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 (,). The row separator
(separating elements in one column) is the semicolon (;). To create a two-dimensional array,
separate the items in each row by commas, and in each column by semicolons.
Note: The row separator is always the semicolon (;),
but the column separator is the dot (.) in German locale. If you input the wrong separator, IBM Docs does not accept it and
you cannot get your expected result.
Arrays cannot be nested.
Examples
| Array | Description |
|---|---|
| ={1,2,3} | An array with one row consisting of the three numbers 1, 2, and 3. |
| ={1;2;3} | An array with one column consisting of the three numbers 1, 2, and 3. |
| =SUM({1,2,3}) | Returns 6, the result of SUM calculation with the arguments 1, 2, and 3. |
| =SUM({1,2,3;4,5,6}) | Entered as an array formula, returns 21, the result of SUM calculations with the arguments 1, 2, 3 and 4, 5, 6. |
| Array constant types | Examples |
|---|---|
| Double quote string | "So" |
| Boolean | TRUE/FALSE |
| Number | 1, 2... |
| Error | #VALUE!/#NUM/!#REF!/#DIV/0!/#NULL!/#N/A/#NAME? |