Search

 

Module: Editor

Version: 5.1.4 +

Type: Long, Double, Date, Boolean or String

Category: Matrix

 

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:

Column1Column2Column3Column4
 2 4
 3

 

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.

Updated: 2014-09-12