# EXCEL FUNCTIONS-CELL

## INTRODUCTION

CELL FUNCTION comes under the INFORMATION category in Excel.CELL FUNCTION gives us a lot of information about any cell or the contents stored in the cell.This kind of information may be needed when we are writing a code for the MACRO or making any complex formulawhere we need to check the content or the properties of the cell to decide the further action.

Returns information about the formatting, location, or contents of the upper-left cell in a reference.

## PURPOSE OF CELL FUNCTION IN EXCEL

CELL FUNCTION returns the content , properties or location of any specified cell.

## PREREQUISITES TO LEARN CELL

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

•  Basic understanding of how to use a formula or function.
•  Basic understanding of rows and columns in Excel.
•  Of course, Excel software.

What Excel does? How to use formula in Excel?

## SYNTAX: CELL FUNCTION

The Syntax for the function is

INFORMATION TYPE  Type of information needed.

Different types of information available are enlisted in next section.

CELL ADDRESS Cell address of the location, of which information will be displayed.

## INFORMATION TYPE AVAILABLE FOR CELL FUNCTION

DIFFERENT INFORMATION TYPE AVAILABLE ARE

In addition to these types, there are different codes which are returned in the “FORMAT” options. The following table gives the information about those codes.

## FORMAT OPTION IN CELL FUNCTION

FOLLOWING ARE THE CODES WHICH ARE RETURNED WHEN  A CELL HAS ANY FORMAT FROM THE BUILT IN NUMBER FORMATS IN EXCEL.

Let us take the same line from the introduction and try our latest learnt function on that.

## EXAMPLE:CELL FUNCTION IN EXCEL

### DATA SAMPLE

We will try to use Cell function with different types of attributes. The CELL function will return the attribute which is asked for.

Let us check the different attributes of G7 TO G11.

For the example,

we have taken few attributes.

Address, type, row, col and format.

The picture below shows the application of the function

and output after applying the function with different attributes.

### STEPS TO USE CELL FUNCTION (EXAMPLE )

The sample text is contained in the cells G7 to G11. The content can be numbers text or anything else. The CELL function mostly displays the information about the features of the cells.

The Functions are put in the RESULT COLUMN as =CELL(“ADDRESS”,G7) =CELL(“TYPE”,G8) =CELL(“ROW”,G9) =CELL(“COL”,G10) =CELL(“FORMAT”,G11)

for address, type , row , column and format respectively.

The function used is also given in the next cell.

as we can see the structure of the function is as per syntax,

=CELL(“ATTRIBUTE”, REFERENCE).

The outputs can be matched with the mentioned tables.

IF REFERENCE IS NOT GIVEN OR ANY CELL ADDRESS IS NOT GIVEN, THE FUNCTION WILL APPLY TO THE LAST EDITED CELL.