The CELL function returns information about a cell in a worksheet. The type of information to be returned is specified as info_type. CELL can get things like address and filename, as well as detailed info about the formatting used in the cell.
Purpose of Excel CELL Function
Get information about a cell.
A text value.
=CELL (info_type, [reference])
|info_type||The type of information to return about the reference.||Mandatory|
|reference||The reference from which to extract information.||Optional|
- When reference refers to more than one cell, CELL will return information about the first cell in reference.
Since 2007 for Windows.
Since 2011 for Mac.