Difference between revisions of "Manuals/calci/CELL"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | 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 | =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. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
| Line 66: | Line 30: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="SelectTD SelectTD " | | | class="SelectTD SelectTD " | | ||
| − | |||
| | | | ||
| | | | ||
| Line 89: | Line 52: | ||
|} | |} | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | Let's C1R1= PLACE | |
| − | + | then =CELL(“contents”,B2) is PLACE | |
| − | |||
Revision as of 04:23, 20 November 2013
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