In this chapter, we will look into some of the information functions provided by Excel. These functions give information about the contents of a cell, formula, sheet, worksheet, or operating environment.
Let us now look into the information functions.
CELL Function
The CELL function is used to return information about a cell, or the first cell if it is a range.
Syntax
=CELL(info_type, [reference])
The CELL function takes two arguments, as follows:
The first argument is the type of information to return about the reference. Table 10-1 shows the values that this argument can take. ...
