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 |