Investment Studio > Expressions > Functions > Reference > ROW
| Implicit form: | integer row() Returns the row number of the cell containing the expression. |
| Scalar form: | integer row(reference cell_reference) Returns the row number of the referenced cell. |
| Array form: | integer array[*][1]
row(reference range_reference) Returns a column vector with the referenced row numbers. |
Examples
=row()
in cell B9 of the spreadsheet in the Macros view returns 9 (for row 9)
=row(C7)
returns 7 (for row 7)
=row(E4:G5)
returns {{4}, {5}} (for rows 4, 5).