deepcalc
DocsCELL

CELL

View as markdown/docs/functions/cell.md Ask Claude about this pageOpens Claude with this page's address

Information about a cell's formatting, location or contents.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Any value

Examples

=CELL("row", A2)
A
2 20
Result 2

Syntax

CELL(info_type, [reference])
info_type
text required
reference
range optional

Errors

#VALUE!
=CELL(2)
ERROR.TYPEReturns number corresponding to an error type. FORMULATEXTReturns formula as a text string. INFOInformation about the operating environment. ISBLANKReturns TRUE if value is blank. ISDATETrue when a value can be read as a date. ISEMAILTrue when text looks like an email address.