Buzz
When you want to uncover details like formatting, absolute address, data types... of a cell in an Excel spreadsheet, CELL() function is your best friend. It's widely used to retrieve cell information in Excel. So, how do you use CELL() and what's its syntax? Let's explore in this article.
This article provides a detailed description of the syntax and usage of the CELL() function to retrieve information about a cell in Excel.
Description
Unlocking Excel's Potential with the CELL Function
Syntax
=CELL(info_type, reference)
Where:
- info_type: The type of information you want the CELL() function to return.
- reference: The cell or range of cells you want to retrieve information about.
+ If reference is omitted, the function defaults to returning information about the cell containing the CELL() function.
+ If reference is a range of multiple cells or a reference to a range of multiple cells, the CELL() function returns information about the cell in the upper-left corner of that range of cells.
Note
- The table of values for the Info_type parameter and the corresponding results.
- The table below describes the values returned by the CELL() function when the Info_type parameter is 'format'.
- Info_type must be entered within double quotes; otherwise, the CELL() function returns the #NAME! error.
- If the info_type is not appropriate, the CELL() function returns the #VALUE! error.
Example
This article has introduced you to the CELL() function for retrieving information about a cell in Excel. CELL() supports various types of information retrieval that you can choose based on your needs. When you need to look up specific information, you can select the appropriate type of information according to your requirements. Wish you success!
