CELL Function in Excel

Hi everyone, Today we will discuss Excel CELL Function. Here, We would learn how to use CELL Function and how it works.CELL Function is widely used for displaying the information about a cell in an Excel Sheet.It can return any type of information like filename, address, content or cell formatting information etc. CELL Function is very useful tool in Excel, Let’s discuss it in details.

Image result for CELL Function excel

What is CELL Function?

CELL Function is a very useful function of Excel.It returns the information about the cell in Excel, like location, content or formatting information about the cell. The type of information we want to get can be specified as the info_type argument of CELL Function.For example, If you want to find out the location of any cell, it is protected or not, What type of formatting has been done on a specific cell, we can use CELL Function for all of the information.

How can we use CELL Function?

Syntax of CELL Function:

=CELL(info_type, [reference])

ARGUMENTS:

  • info_type: It is the required parameter of CELL Function, wherein we specify what kind of information about the cell we want.Here is a list of info_type we can specify as our info_type argument.

 

Info_type Description
address returns the address of the first cell in reference (as text).
col returns the column number of the first cell in reference.
color returns the value 1, on the off chance that the main cell in reference is designed utilizing shading for negative values; or zero if not.
contents returns the value of the upper-left cell in reference. Formulas are not returned. Instead, the result of the formula is returned.
filename restores the record name and full way as text. In the occasion that the worksheet that contains reference has not yet been saved, an empty string is returned.
format returns a code that corresponds to the number format of the cell. See below for a list of number format codes. If the first cell in reference is formatted with color for values < 0, then “-” is appended to the code.On the off chance that the cell is designed with enclosures, returns “() – toward the finish of the code value.
parentheses returns 1 the first cell in reference is formatted with parentheses and 0 if not.
prefix restores a content esteem that compares to the label prefix -of the cell:  a solitary quote (‘) if the cell content is left-adjusted, a double quotation mark (“) if the cell text is right-aligned, a caret (^) if the cell text is centered text, a backslash () if the cell text is fill-aligned, and an empty string if the label prefix is anything else.
protect returns 1 if the first cell in reference is locked or 0 if not.
row returns the row number of the first cell in reference.
type returns a text value that corresponds to the type of data in the first cell in reference:  “b” for blank when the cell is empty, “l”  for the label if the cell contains a content steady, and “v” for esteem if the cell contains whatever else.
width returns the column width of the cell, rounded to the nearest integer. A unit of column width is equal to the width of one character in the default font size.

The following table describes the returned value when the info_type argument is specified as “format”.

Format code returned Format code meaning
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
  • [reference]: It is an optional argument,here we specify the cell or a range of cells for which we want to retrieve the information.

So, This is how we use CELL Function in Excel. If you think this article was helpful to you in understanding and implementing CELL Function practically, We would love if you can also share this article on Social media platforms  to help them out with Excel Concepts.If you have any queries about CELL Function, Kindly post it to us and we would try to help you out as soon as possible.

Add a Comment

Your email address will not be published. Required fields are marked *