Changes

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"

|- 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="sshl_f" | ~~ROW(A6)~~

+

| class=" " | Row3

−

| class="~~sshl_f~~" | 6

+

| class="sshl_f" |

−

+

| class=" " |

+

| class=" " |

+

| class=" " |

|- 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 ==

Swapna

writer

2,661

edits