Manuals/calci/CELL

CELL(type,reference)

• $type$ specifies what type of information we want.
• $references$ is the cell we want to retrieve information.

Description

• This function is used to retrieve information about a cell
• The information about the cell can be the contents,size, formatting etc.
• $type$ specifies what type of information we want.
• $references$ is the cell we want to retrieve information.
• $references$ is optional.
• If $references$ is omitted, the last cell that was changed will be taken

Type	Value Returned
"address"	Address of the cell. If the cell refers to a range, it is the first cell in the range.
"col"
"color"
"contents"
"filename"
"format"
"parentheses"
"prefix"
"protect"
"row"
"type"
"width"

See Also

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