Difference between revisions of "Manuals/calci/ROW"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
 
=ROW(reference)=
 
=ROW(reference)=
  
*where 'reference' is a cell or range of cells for which the row number is to be found.
+
*where <math>reference</math> is a cell or range of cells for which the row number is to be found.
  
 
ROW() displays the row number of a reference.
 
ROW() displays the row number of a reference.
Line 14: Line 14:
  
 
*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 <math>reference</math> 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
 
For Example, if the function is written in cell number 7, the function
  

Revision as of 16:19, 12 December 2013

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