Manuals/calci/GETROW

Revision as of 14:42, 4 January 2018 by Devika (talk | contribs)

GETROW (Array,Row)

  •   is any set of values.
  •   is the row number.

Description

  • This function gives the particular row values from the given set of values.
  • In  ,  is the set of values,  is the row number in the given array.
  • So this function displays the specified row values from the given set of values.
  • If we omitted the row number then this function will shows the result as Null for all number of rows.

Examples

  1. GETROW([[1,2,3],[9,8,7],[10,11,12]],2) = 9 8 7
  2. GETROW([[3,-12],[-9,3],[45,-7.2],[-4,-2],[-100,65]],3) = 45 -7.2
  3. GETROW([[1,4.3,8.9,7],[12,-5.6,3/4,-1.22],[-23,12,-3/4,-2.21],[-20,-6.7,9.0,0],[0,-1,2/3,4.9]],5) = 0 -1 0.6666666666666666 4.9

See Also

References