[]
        
(Showing Draft Content)

CELL

This function returns information about the formatting, location, or contents of a cell.

Syntax

CELL(info_type, [reference])

Arguments

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.

Examples

CELL("row", B1)

CELL("contents", B3)

CELL("type", B4)