Returns information about the address, format, or content of a given cell.
Syntax
CELL(info_type; cell_ref
)
info_type: Text string that determines which information to return. E.g. "WIDTH"
info_type |
Description |
COL |
CELL() returns the column number of the referenced cell. |
ROW |
CELL() returns the row number of the referenced cell. |
SHEET |
CELL() returns the sheet number of the referenced cell. |
ADDRESS |
CELL() returns the absolute address of the referenced cell as text. |
COORD |
CELL() returns the complete cell address in Lotus (TM) notation as text. |
CONTENTS |
CELL() returns the contents of the upper-left most cell in a given range. |
TYPE |
CELL() returns text that indicates the type of cell contents in the referenced cell.
|
WIDTH |
CELL() returns the column width of the referenced cell. The unit is the number of zeros (0) that fit into the column in the default font and size. |
PREFIX |
CELL() returns text that indicates the alignment of the referenced cell.
|
FORMAT |
CELL() returns text that indicates the number format in the referenced cell.
|
COLOR |
CELL() returns 1 if the cell has number format to color negative values, and 0 otherwise. |
PARENTHESES |
CELL() returns 1 if the format code contains an opening bracket '(', and 0 otherwise. |
Examples
Formula |
Result |
=CELL("ADDRESS";A2) |
$A$2 |
=CELL("CONTENTS";A2:A4) |
500 |
=CELL("WIDTH";A4) |
100 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com