Difference between revisions of "Manuals/calci/COLUMN"

From ZCubes Wiki
Jump to navigation Jump to search
Line 4: Line 4:
  
 
==Description==
 
==Description==
*This function gives the position of the column number for the 'rf'.  
+
*This function gives the position of the column number for the <math>rf</math>.  
*i.e.COLUMN(B12)= 2 because Column number 2 is B
+
*i.e COLUMN(B12)= 2 because Column number 2 is B
*When we are not giving the 'rf', it is assumed to be the same cell where function COLUMN is displayed.   
+
*When we are not giving the <math>rf</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.  
 
*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 indicate as a multiple sheets.
+
*<math>rf</math> cannot indicate as a multiple sheets.
  
 
==Examples==
 
==Examples==
  
*COLUMN(F2) is 6 , because F2 is in the position of 6th column.
+
*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.
Line 22: Line 22:
  
 
==References==
 
==References==
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers]
+
[Column]

Revision as of 07:39, 19 November 2013

COLUMN(rf)


  • is the cell of particular range of cells.

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.

See Also

References

[Column]