CELL Function In Excel

The CELL function returns the information about cell references by taking 2 arguments, such as what info is needed, whether the cell values location, format, address, and which cell value to find the required details.

The Formula of the CELL function is =CELL(info_type,reference)

We can insert Excel CELL Function as follows:
1. Select an empty cell for the output.
2. Type =CELL( in the selected cell. [Alternatively, type =C and double-click the CELL function from the list of suggestions shown by Excel.]
3. Enter the arguments as cell values or cell references and close the brackets.
4. Press the “Enter” key.

For example, we will find the cell content using the CELL function for the following values.



Select cell B2, enter the formula =CELL(“contents”,A2), and press the “Enter” key.



The result is ‘10’, as shown above.

The CELL Excel Function is found in the “Formulas” tab, as shown below.

Choose an empty cell for the output → select the “Formulas” tab → go to the “Function Library” group → click the “More Functions” option drop-down → click the “Information” option right arrow → select the “CELL” function, as shown below.