Difference between revisions of "Manuals/calci/COLUMNS"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''COLUMNS(arr)'''</div><br/> | <div style="font-size:30px">'''COLUMNS(arr)'''</div><br/> | ||
| − | * | + | *<math>arr</math> is an array or a reference to a range of cells. |
==Description== | ==Description== | ||
*This function gives the number of columns in an given array or in the reference of cell range. | *This function gives the number of columns in an given array or in the reference of cell range. | ||
| − | *i.e.COLUMNS(A3:H5)is 8 because number of cells | + | *i.e.COLUMNS(A3:H5)is 8 because number of cells from cell A3 to H5 is 8. |
==Examples== | ==Examples== | ||
| − | *COLUMNS(D5:G8) is 4,because number of columns in between D5 to G8 is 4 | + | *COLUMNS(D5:G8) is 4, because number of columns in between D5 to G8 is 4 |
| − | *COLUMNS(R5:G4) is 12 , because it will considered as G4 to R5 | + | *COLUMNS(R5:G4) is 12, because it will considered as G4 to R5. So in between columns is 12. |
*=COLUMNS({2,4,6,8,0;1,3,5,7,9}) is 5, because it is giving the number of constants in the given array. | *=COLUMNS({2,4,6,8,0;1,3,5,7,9}) is 5, because it is giving the number of constants in the given array. | ||
Revision as of 05:52, 18 November 2013
COLUMNS(arr)
- is an array or a reference to a range of cells.
is an array or a reference to a range of cells.Description
- This function gives the number of columns in an given array or in the reference of cell range.
- i.e.COLUMNS(A3:H5)is 8 because number of cells from cell A3 to H5 is 8.
Examples
- COLUMNS(D5:G8) is 4, because number of columns in between D5 to G8 is 4
- COLUMNS(R5:G4) is 12, because it will considered as G4 to R5. So in between columns is 12.
- =COLUMNS({2,4,6,8,0;1,3,5,7,9}) is 5, because it is giving the number of constants in the given array.