Difference between revisions of "Manuals/calci/COLUMN"

From ZCubes Wiki
Jump to navigation Jump to search
 
(15 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div style="font-size:30px">'''COLUMN(rf)'''</div><br/>
+
<div style="font-size:30px">'''COLUMN (Array)'''</div><br/>
 +
 
 +
*<math>Array</math> is the cell of particular range of cells.
 +
**COLUMN(), returns the column number of a reference
  
*'rf' is the cell of particular range of cells.
 
  
 
==Description==
 
==Description==
*This function gives the position of the column number for the 'rf'.i.e. COLUMN(B12)= 2 because Bth column is displaying in the 2nd position.when we are not giving the 'rf',it is assumed to be the same cell where function COLUMN is dispalys.  If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array formula, the COLUMN function returns the number of the leftmost column. 'rf'  cannot indicte as a multiple sheets.
+
*This function gives the position of the column number for the <math>Array</math>.  
 +
*i.e COLUMN(B12)= 2 because Column number 2 is B
 +
*When we are not giving the <math>Array</math>, it assumes the same cell where function COLUMN is displayed.   
 +
*If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array formula, the COLUMN function returns the number of the leftmost column.  
 +
*<math>Array</math> cannot indicate as a multiple sheets.
  
*COLUMN(F2) is 6 , because F2 is in the position of 6th column.
+
==Examples==
 +
 
 +
*COLUMN(F2) is 6, because F2 is in the position of 6th column.
 
*COLUMN() this will give the result where the function is displayed
 
*COLUMN() this will give the result where the function is displayed
 
*COLUMN(B1:F2) is 2, because it will give the result where the B1 is displayed.
 
*COLUMN(B1:F2) is 2, because it will give the result where the B1 is displayed.
  
 +
==Related Videos==
  
==Examples==
+
{{#ev:youtube|4j0vJiYCHg4|280|center|COLUMN}}
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| CHIDIST(x,df)
 
! x
 
! df
 
! RESULT
 
|-
 
|- class="odd"
 
|CHIDIST(18,2)
 
|18
 
|2
 
|0.0001234098
 
|- class="even"
 
|CHIDIST(15,1)
 
|15
 
|1
 
|0.0001075112
 
|- class="odd"
 
|CHIDIST(2,1)
 
|2                                     
 
|1
 
|0.157299207050
 
|- class="even"
 
|CHIDIST(-2,1)
 
|(-)2
 
|1
 
|error
 
|- class="odd"
 
|CHIDIST(2,-1)
 
|2                                     
 
|(-)1
 
|error
 
|}
 
  
 
==See Also==
 
==See Also==
 +
*[[Manuals/calci/COLUMNS | COLUMNS]]
 +
*[[Manuals/calci/ROW | ROW]]
  
*[[Manuals/calci/CHITEST | CHITEST]]
+
==References==
 +
*[http://www.techonthenet.com/excel/formulas/column.php Column]
  
==References==
+
 
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
+
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |   Z3 home ]]

Latest revision as of 17:11, 6 August 2018

COLUMN (Array)


  • is the cell of particular range of cells.
    • COLUMN(), returns the column number of a reference


Description

  • This function gives the position of the column number for the .
  • i.e COLUMN(B12)= 2 because Column number 2 is B
  • When we are not giving the , it assumes the same cell where function COLUMN is displayed.
  • If the reference argument is a range of cells, and if the COLUMN function is not entered as a horizontal array formula, the COLUMN function returns the number of the leftmost column.
  • cannot indicate as a multiple sheets.

Examples

  • COLUMN(F2) is 6, because F2 is in the position of 6th column.
  • COLUMN() this will give the result where the function is displayed
  • COLUMN(B1:F2) is 2, because it will give the result where the B1 is displayed.

Related Videos

COLUMN

See Also

References