Difference between revisions of "Manuals/calci/ROW"

From ZCubes Wiki
Jump to navigation Jump to search
Line 11: Line 11:
 
For Example,
 
For Example,
  
ROW(B5) ''returns 5''.
+
ROW(B5) ''returns 5'' as a result.
  
 
*The function gives the row number of a cell specified or the function where it is placed.
 
*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.
 
*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 ==
 
== Examples ==

Revision as of 18:23, 11 December 2013

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