## What Is CELL Function In Excel?

The

CELL function in Excelextracts and returns the requested information about a cell value regarding its contents, formatting, location, etc. In a large dataset, the function helps identify numeric values before proceeding with any calculations. TheExcel CELL functionis an inbuiltInformationfunction, so we can insert the formula from the “Function Library” or enter it directly in the worksheet. For example, we will use theCELL functionto find the cell address for the value in column A.

Select cell **B2**, enter the formula ** =CELL(“address”,A2), **and press “

**Enter**”. The result is

**‘$A$2’**, as shown below, indicating that the selected cell’s cell address is

**A2**.

###### Key Takeaways

- The
**CELL function in Excel**helps users find the needed facts or information w.r.t a cell value in a given dataset. - The
tells what kind of information is required, such as its cell address, formatting [color, format, etc.], location [column, row, etc.], etc.*info_type* - We can see the “
**Info-type**” table and the “**Format Code**” table provided, at the start of the article, to comprehend what results or output to expect when the function is executed. - For the
argument, we must select the cells in a dataset or a cell range, apply the*reference***CELL formula,**and extract the required details.

### CELL() Excel Formula

The syntax of the **CELL Excel Formula** is,

The arguments of the **CELL Excel Formula** are,

: It is a mandatory argument. It is the cell information that is to be returned.*info_type*

**Info Type value – **The table below contains the Info type and its description.

Info Type | Description |
---|---|

Address | Returns the address of the first cell as text. |

Col | Returns the column number of the first cell. |

Color | Returns the value 1 for negative values and value 0 for others if the cell is formatted in color. |

Contents | Returns the value of the upper left cell but not the formula cell. |

Filename | Returns the Filename that includes the full path of the file as text. If the content is not yet saved, it returns empty text (“”). |

Format | Returns the code which is corresponding to the number format of the cell. |

Parentheses | Returns the value 1 for the first cell formatted as parentheses; otherwise, returns the value 0. |

Prefix | Returns text value based on the specified “label prefix” of the cell. |

Protect | Returns the value 0 if the cell is not locked; otherwise, returns the value 1. |

Row | Returns the row number of the cell. |

Type | Returns the text value, which depends on the type of data, i.e., ‘b’ for blank cell, ‘l’ for the label, & ‘v’ for value. |

Width | Returns the column width. |

**Cell Format Codes**

Format Code | Description |
---|---|

G | General |

F0 | 0 |

,0 | #,##0 |

F2 | 0 |

,2 | #,##0.00 |

C0 | $#,##0_);($#,##0) |

C0- | $#,##0_);[Red]($#,##0) |

C2 | $#,##0.00_);($#,##0.00) |

C2- | $#,##0.00_);[Red]($#,##0.00) |

P0 | 0% |

P2 | 0.00% |

S2 | 0.00E+00 |

G | # ?/? or ??/?? |

D1 | d-mmm-yy or dd-mmm-yy |

D2 | d-mmm or dd-mmm |

D3 | mmm-yy |

D4 | m/d/yy or m/d/yy h:mm or mm/dd/yy |

D5 | Mm/dd |

D6 | h:mm:ss AM/PM |

D7 | h:mm AM/PM |

D8 | h:mm:ss |

D9 | h:mm |

: It is an optional argument. It is the cell from which the information is collected.*reference*

### How To Use CELL Function In Excel?

We can use the **CELL function in Excel **in 2 ways, namely,

**Access from the Excel ribbon.****Enter in the worksheet manually.**

#### Method #1 – Access from the Excel ribbon

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.

The **“Function Arguments” **window appears. Enter the arguments in the **“Info_type” **and** “Reference”** fields → click “**OK”, **as shown below.

#### Method #2 – Enter in the worksheet manually

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

Let us take a basic example to understand this function.

We will find the formatting of the cell values **using** **CELL function in Excel**.

In the table, the data is,

- Column A contains the Data.
- Column B contains the Result.

The steps to find the required details using the **CELL formula **are**,**

**Select cell B2, and enter the formula =CELL(“format”, i.e., the format value of the cell.****Enter the value of ‘reference’ as A2, and close the brackets. The complete formula is =CELL(“format”,A2).****Press the “Enter” key. The results in cell B2, as shown below.****Drag the formula from cell B2 to B6 using the fill handle. The output is shown below.**

### Examples

We will understand some advanced scenarios using the **CELL function in Excel examples.**

#### Example #1

We will find the column cell reference of the cell values using the **CELL function in Excel**.

In the table, the data is,

- Column A contains the Data.
- Column B contains the Result.

The steps to find the required details using the **CELL formula **are**,**

**Step 1:**Select cell**B2**, enter the formulaand press “*=CELL(“col”,A2),***Enter**”. The result is ‘**1**’, as shown below, indicating the column number of the selected cell.

**Step 2:**Drag the formula from cell**B2**to**B5**using the fill handle. The output is shown below.

#### Example #2

We will find the prefix of the cell values using the **CELL function in Excel**.

In the table, the data is,

- Column A contains the Data.
- Column B contains the Result.

The steps to find the required details using the **CELL formula **are**,**

**Step 1:**Select cell**B2**, enter the formulaand press “*=CELL(“prefix”,A2),***Enter**”. The result is**’.**

**Step 2:**Drag the formula from cell**B2**to**B5**using the fill handle. The output is shown below.

#### Example #3

We will find the color of the cell values using the **CELL function in Excel**.

In the table, the data is,

- Column A contains the Data.
- Column B contains the Result.

The procedure to find the required details using the **CELL formula **is**,**

Enter the formula ** =CELL(color, A2) **in cell

**A2**,

**=CELL(“abc”,A3)**in cell

**A3,**and

**=CELL(6,A4)**in cell

**A4**. Press the “

**Enter**” key every time the formula is entered.

The result in cell **B2** is a **“#NAME?”** error”, and in cells **B3 **and** B4** are **“VALUE!”** errors, as shown in the image above. Column C is for our reference.

### Important Things To Note

- The
**“#NAME?”**error occurs when the “” arguments are text values that are not enclosed in quotes (“ ”) and are not valid cell references.*info_type* - The
**“#VALUE!”**error occurs when,- The “
” value is less than one or is greater than the given number of values.*info_type* - The “
” argument value is non-numeric.*info_type*

- The “

### Frequently Asked Questions (FAQs)

**1. What does the CELL function in Excel mean?**

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)*

**2. How to insert the CELL function in Excel?**

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.

**3. Where is the CELL function in Excel?**

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.

### Download Template

This article must help understand the **CELL function in Excel’s **formula and examples. You can download the template here to use it instantly.

### Recommended Articles

This has been a guide to CELL Function In Excel. Here we explain how to use CELL formula along with examples & downloadable excel template. You can learn more from the following articles –

## Leave a Reply