Module: Editor
Version: 5.1.4 +
Description
The formula 'Index' returns a value (integer, real number, date, boolean or text) at the intersection of a specified row and column.
Parameters
Matrix: the matrix you want to select a value from.
Row: is the row index. First row is indicated by 0.
Column: is the column index. First columnis indicated by 0.
Example
Description
In the following example the formula 'Index' is used to select the value in the bottom right.
Values parameters
Matrix:
| Column1 | Column2 | Column3 | Column4 |
|---|
| 2 |
4 |
6 |
8 |
| 3 |
5 |
7 |
9 |
Row: 1
Column: 3
Result
Value: 9
The result is the value in the second row, fourth column of the matrix.
Related Topics
-
Feedback
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.