Difference between revisions of "Manuals/calci/CELL"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
+ | <div style="font-size:30px">'''CELL(info_type,reference)'''</div><br/> | ||
+ | *<math>info_type</math> specifies what type of information we want. | ||
+ | *<math>references</math> is the address of the cell.' | ||
+ | |||
This function gives the information about the formatting, location, or contents of the upper-left cell in a reference. | This function gives the information about the formatting, location, or contents of the upper-left cell in a reference. | ||
Let's see an example if an element is placed in the B4 cell,i.e 4th row | Let's see an example if an element is placed in the B4 cell,i.e 4th row |
Revision as of 04:30, 20 November 2013
CELL(info_type,reference)
- specifies what type of information we want.
- is the address of the cell.'
This function gives the information about the formatting, location, or contents of the upper-left cell in a reference. Let's see an example if an element is placed in the B4 cell,i.e 4th row
then =CELL(“row”,B2) is 2 =CELL(“row”,B3) is 3
where Infotype is a text value that specifies what type of cell information that want. And 'ref' is the cell that want information about.
Column1 | Column2 | Column3 | Column4 | |
Row1 | 12 | 2 | ||
Row2 | 5 | 3 | ||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |
Let's C1R1= PLACE
then =CELL(“contents”,B2) is PLACE