CELL function to look up information of a cell in Excel

When you want information about the format, absolute address, data type, etc. of a cell in an Excel spreadsheet, you should use the CELL () function. The CELL () function is used a lot to look up a cell's information in Excel. So the syntax and usage of CELL () function like, you follow the article below.

CELL function to look up information of a cell in Excel Picture 1

The article describes in detail the syntax and usage of the CELL () function to look up a cell's information in Excel ().

Description

CELL () returns the format, position, or content information of a cell depending on your needs. When you need to look up a cell's information, CELL () is the most used function.

Syntax

= CELL (info_type, reference)

Inside:

- info_type: type of lookup information you want the CELL () function to return.

- reference: the cell or range you want to look up information.

+ If reference is omitted, the function will default to return information of the cell containing the CELL () function.

+ If reference is a range of cells or a reference to a range of cells, CELL () results in the information of the top-left cell on the range of cells and range of cells.

Note

- Table of values ​​of the Info_type argument and results returned.

CELL function to look up information of a cell in Excel Picture 2

CELL function to look up information of a cell in Excel Picture 3

- The following table describes the value that the CELL () function returns when the Info_type argument is "format".

CELL function to look up information of a cell in Excel Picture 4

CELL function to look up information of a cell in Excel Picture 5

- Info_type must be entered in quotation marks, otherwise CELL () will return the #NAME! Error.

- If info_type is not appropriate, CELL () returns the #VALUE! Error.

For example

CELL function to look up information of a cell in Excel Picture 6

The article introduced to you CELL () function to look up information of a cell in Excel. CELL () function supports many types of information that you can look up, tailored to each person's needs. When you need to look up information, you can choose the type of information to look up for the request. Good luck!