Difference between revisions of "Manuals/calci/CELL"

From ZCubes Wiki
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 05: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