How do you insert a function in a cell in Excel?

The CELL function is used to get information about a cell. This can be things like its address, format, filename etc. While some of those things can be obvious, there are times when it is useful to get them. If you are looking for the address of a cell that has been given a name for example, as in the following example. The characteristic that you are looking for must be enclosed in brackets, and they are given to you to choose from as you enter the function. The following example gets the address of a cell that has been given the name TotalSales.

=CELL("address", TotalSales)