CELL Function Explained
The CELL function in Microsoft Excel returns information about the formatting, location, or contents of a cell. It takes two arguments: info_type and reference. The info_type argument is a text value that specifies the type of cell information you want to return. The reference argument is a cell reference for which you want to return information.
CELL Function Syntax
CELL(info_type, [reference])
- info_type: A text value that specifies the type of information you want returned. Possible values are “address”, “col”, “color”, “contents”, “filename”, “format”, “parentheses”, “prefix”, “protect”, “row”, “type”, and “width”.
- [reference]: An optional cell reference that specifies the cell from which you want to return information. If omitted, the reference is assumed to be the cell in which the CELL function appears.