information about a cell's formatting, location or contents · from excel · excel: not yet compared · sheets: not yet compared

signature

CELL(info_type, [reference])

returns: any

argument	required
info_type	required
reference	optional

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

errors

error values observed from the engine — each with a call that produces it.

error	produced by
#VALUE!	=CELL(2)

related

• ERROR.TYPE returns number corresponding to an error type
• FORMULATEXT returns formula as a text string
• INFO information about the operating environment
• ISBLANK returns TRUE if value is blank
• ISDATE true when a value can be read as a date
• ISEMAIL true when text looks like an email address