Manuals/calci/ROW

Revision as of 16:19, 12 December 2013 by Swapna (talk | contribs)

ROW(reference)

  • where   is a cell or range of cells for which the row number is to be found.

ROW() displays the row number of a reference.

Description

ROW(reference)

For Example,

ROW(B5) returns 5 as a result.

  • The function gives the row number of a cell specified or the function where it is placed.
  • If   is omitted, the function returns the row number of the cell where the function is written.

For Example, if the function is written in cell number 7, the function

ROW() returns 7 as a result.

Examples

Function ROW Output
ROW(A6) 6
ROW(A4:C4) 4

See Also

References