Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/ROW
(view source)
Revision as of 21:31, 9 August 2018
47 bytes added
,
21:31, 9 August 2018
no edit summary
Line 1:
Line 1:
=ROW(reference)=
=ROW(reference)=
+
<div style="font-size:30px">'''ROW (Array) '''</div><br/>
−
*where <math>
reference
</math> is a cell or range of cells for which the row number is to be found.
+
*where <math>
Array
</math> is a cell or range of cells for which the row number is to be found.
−
+
**
ROW()
, returns
the row number of a reference.
−
ROW()
displays
the row number of a reference.
== Description ==
== Description ==
−
ROW(reference)
ROW(reference)
−
+
*
For Example,ROW(B5) ''returns 5'' as a result.
−
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.
*The function gives the row number of a cell specified or the function where it is placed.
−
*If <math>
reference
</math> is omitted, the function returns the row number of the cell where the function is written.
+
*If <math>
Array
</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
Devika
writer
6,694
edits