Retrieve various information such as the format and lock status of the specified cell.
This function is not available online.
How it works
=CELL(info_type,reference)
| Argument | Omission | Explanation |
|---|---|---|
| info_type | Required argument. Details to follow. | |
| reference | Target cell. |
info_type
address
Gets the top-left address of the range of cells specified.
The result is an absolute reference.
col
Retrieves the top-left-most column number of a given cell range.
However, the COLUMN function is better.
color
If it is a negative number, it is set to 1 if the format changes the character color, otherwise it is set to 0.
contents
Returns the value of a cell.
There is no need to use this function.
filename
The location where the file was saved and the sheet name of the target cell.
If not saved in a file, it will be blank.
format
Returns the set format.
Returns a specific code.
| Format | Result |
|---|---|
| General | G |
| 0 | F0 |
| #,##0 | ,0 |
| 0.00 | F2 |
| #,##0.00 | ,2 |
| $#,##0_);($#,##0) | C0 |
| $#,##0_);[red]($#,##0) | C0- |
| $#,##0.00_);($#,##0.00) | C2 |
| $#,##0.00_);[red]($#,##0.00) | C2- |
| 0% | P0 |
| 0.00% | P2 |
| 0.00E+00 | S2 |
| # ?/? # ??/?? | G |
| m/d/yy m/d/yy h:mm mm/dd/yy | D4 |
| d-mmm-yy dd-mmm-yy | D1 |
| d-mmm dd-mmm | D2 |
| mmm-yy | D3 |
| mm/dd | D5 |
| h:mm AM/PM | D7 |
| h:mm:ss AM/PM | D6 |
| h:mm | D9 |
| h:mm:ss | D8 |
parentheses
The result is 1 if the cell is formatted with positive values or all values enclosed in parentheses (), or 0 if the cell is not formatted.
It is not often used.
protect
If the cell is locked, the value is "1"; otherwise, it is "0".
row
Retrieves the top-left-most row number of a given cell range.
However, the COLUMN function is better.
type
The type of input value.
| Type | Result |
|---|---|
| Blank | b |
| Text | l |
| Others | v |
The following functions are better: ISBLANK, ISTEXT, ISNUMBER, ISLOGICAL.
width
Gets how many characters wide the cell is in standard font.
---