writer
6,694
edits
Changes
Jump to navigation
Jump to search
Created page with "<div style="font-size:30px">'''GETROW (Array,Row)'''</div><br/> *<math>Array</math> is any set of values. *<math>Row</math> is the row number. ==Description== *This function..."
<div style="font-size:30px">'''GETROW (Array,Row)'''</div><br/>
*<math>Array</math> is any set of values.
*<math>Row</math> is the row number.
==Description==
*This function gives the particular row values from the given set of values.
*In <math>GETROW (Array,Row)</math>,<math>Array</math> is the set of values,<math>Row</math> 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==
# GETROW([[1,2,3],[9,8,7],[10,11,12]],2) = 9 8 7
# GETROW([[3,-12],[-9,3],[45,-7.2],[-4,-2],[-100,65]],3) = 45 -7.2
# 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==
*[[Manuals/calci/GETCOLUMN | GETCOLUMN]]
*[[Manuals/calci/COLUMNS | COLUMNS]]
*[[Manuals/calci/ROW | ROW]]
==References==
*[https://exceljet.net/excel-functions/excel-row-function Row]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
*<math>Array</math> is any set of values.
*<math>Row</math> is the row number.
==Description==
*This function gives the particular row values from the given set of values.
*In <math>GETROW (Array,Row)</math>,<math>Array</math> is the set of values,<math>Row</math> 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==
# GETROW([[1,2,3],[9,8,7],[10,11,12]],2) = 9 8 7
# GETROW([[3,-12],[-9,3],[45,-7.2],[-4,-2],[-100,65]],3) = 45 -7.2
# 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==
*[[Manuals/calci/GETCOLUMN | GETCOLUMN]]
*[[Manuals/calci/COLUMNS | COLUMNS]]
*[[Manuals/calci/ROW | ROW]]
==References==
*[https://exceljet.net/excel-functions/excel-row-function Row]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]