The CELL function used to return a specific information of a Excel Cell which you need to know. This function requires a cell address like A1, B1:D6 etc.
Function Structure:
The structure of this function is:
There are 2 parts of this function. These are:
(a) info_type: You need to mention here, which information you would like to know. Like, Color, Address, etc
(b) [reference]: The cell that the information is to be returned for. If you apply [reference] then you will get the mentioned cell's information. But if you omitted it, then this CELL function will return the information of that cell where the =CELL() used.
Example:
Function Structure:
The structure of this function is:
=CELL(info_type,[reference])
There are 2 parts of this function. These are:
(a) info_type: You need to mention here, which information you would like to know. Like, Color, Address, etc
(b) [reference]: The cell that the information is to be returned for. If you apply [reference] then you will get the mentioned cell's information. But if you omitted it, then this CELL function will return the information of that cell where the =CELL() used.
Example:
Image 1: Cell function in details with example