Manuals/calci/ROW

Revision as of 18:23, 11 December 2013 by Swapna (talk | contribs) (→‎Description)

ROW(reference)

  • where 'reference' 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 reference 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