The CELL function returns information about the formatting, location, or contents of a cell and can be very useful in certain situations.

CELL takes 1 required argument and 1 optional argument:

Syntax: CELL(info_type, [reference])

#1)
Using the CELL function:
#2)
The arguments for the CELL function are:
Argument Required? Description
info_type Required All of the info_types available with the CELL function:
reference Optional
The cell that you want information about. If omitted, the information specified in the Info_type argument is returned for the last cell that was changed. If the reference argument is a range of cells, the CELL function returns the information for only the upper left cell of the range.
#3)
Using the "format" info_type has the following possible results:

Summary

The CELL function returns information about the formatting, location, or contents of a cell and can be very useful in certain situations.
comments powered by Disqus