[]
This function returns information about the formatting, location, or contents of a cell.
CELL(info_type, [reference])
Argument | Description |
|---|---|
info_type | [Required] A text value that specifies what type of cell information you want to return. The following list shows the possible values of the Info_type argument and the corresponding results. |
reference | [Optional] The cell that you want information about. If omitted, the information specified in the info_type argument is returned for cell selected at the time of calculation. If the reference argument is a range of cells, the CELL function returns the information for active cell in the selected range. |
CELL("row", B1)
CELL("contents", B3)
CELL("type", B4)