Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Manuals/calci/ROW
(view source)
Revision as of 22:28, 12 December 2013
504 bytes added
,
22:28, 12 December 2013
no edit summary
Line 24:
Line 24:
{| id="TABLE2" class="SpreadSheet blue"
{| id="TABLE2" class="SpreadSheet blue"
|- class="even"
|- class="even"
−
| class=" " |
'''Function'''
+
| class=" " |
−
| class="
" |
'''ROW Output'''
+
| ColumnA
−
+
| ColumnB
+
| ColumnC
+
| ColumnD
+
|- class="odd"
+
| class=" " | Row1
+
| class="sshl_f " | 2
+
| class=" " |
+
| class=" " |
+
| class=" " |
+
|- class="even"
+
| class=" " |
Row2
+
| class="sshl_f" | 5
+
| class=" " |
+
| class=" " |
+
| class=" " |
|- class="odd"
|- class="odd"
−
| class="sshl_f" |
ROW(A6)
+
| class=" " | Row3
−
| class="
sshl_f
" |
6
+
| class="sshl_f" |
−
+
| class=" " |
+
| class=" " |
+
| class=" " |
|- class="even"
|- class="even"
−
| class="
sshl_f
" |
ROW(A4:C4)
+
| class=" " |
Row4
−
| class="
sshl_f
" |
4
+
| class=" " |
+
| class=" " |
+
| class=" " |
+
| class=" " |
+
|- class="odd"
+
| class=" " | Row5
+
| class=" " |
+
| class=" " |
+
| class=" " |
+
| class=" " |
+
|}
−
|}
+
=ROW(A3) : Calculates the row number of cell A3. ''Returns 3'' as a result.
+
=ROW(A4:C4): Calculates the row number in the range A4 to C4. ''Returns 4'' as a result.
== See Also ==
== See Also ==
Swapna
writer
2,661
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Community portal
Current events
Recent changes
Help
Tools
ZCubes Web Platform
Printable version