Difference between revisions of "Manuals/calci/COLUMN"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''COLUMN(rf)'''</div><br/> |
| − | + | *'rf' is the cell of particular range of cells. | |
| − | + | ==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. | |
| − | |||
| − | + | *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. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | ==Examples== | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | | + | | CHIDIST(x,df) |
| − | + | ! x | |
| − | + | ! df | |
| − | + | ! RESULT | |
| − | + | |- | |
| − | | | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHIDIST(18,2) |
| − | | | + | |18 |
| − | + | |2 | |
| − | | | + | |0.0001234098 |
| − | |||
|- class="even" | |- class="even" | ||
| − | | | + | |CHIDIST(15,1) |
| − | | | + | |15 |
| − | | | + | |1 |
| − | + | |0.0001075112 | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHIDIST(2,1) |
| − | | | + | |2 |
| − | + | |1 | |
| − | | | + | |0.157299207050 |
| − | | | ||
|- class="even" | |- class="even" | ||
| − | | | + | |CHIDIST(-2,1) |
| − | | | + | |(-)2 |
| − | + | |1 | |
| − | | | + | |error |
| − | | | ||
|- class="odd" | |- class="odd" | ||
| − | | | + | |CHIDIST(2,-1) |
| − | + | |2 | |
| − | + | |(-)1 | |
| − | + | |error | |
| − | | | ||
| − | |- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
|} | |} | ||
| − | + | ==See Also== | |
| − | + | ||
| − | + | *[[Manuals/calci/CHITEST | CHITEST]] | |
| + | |||
| + | ==References== | ||
| + | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | ||
Revision as of 06:26, 12 November 2013
COLUMN(rf)
- 'rf' is the cell of particular range of cells.
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.
- 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.
Examples
| CHIDIST(x,df) | x | df | RESULT |
|---|---|---|---|
| CHIDIST(18,2) | 18 | 2 | 0.0001234098 |
| CHIDIST(15,1) | 15 | 1 | 0.0001075112 |
| CHIDIST(2,1) | 2 | 1 | 0.157299207050 |
| CHIDIST(-2,1) | (-)2 | 1 | error |
| CHIDIST(2,-1) | 2 | (-)1 | error |