ExcelFlux

CELL function

information about the formatting, location, or contents of a cellThis function is not available in Excel for the web.

Information · Guided Excel example

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Return a cell’s absolute address. Changing the information type can also change the result type.

A worked example from the workbook

RowA
6Input
71
82
93
Record 1
=CELL("address",A7)

Illustrative output$A$7

See the inputs and instructions for all 3 examples

Syntax

CELL(info_type, [reference])

Worked examples

Return a cell’s absolute address. Changing the information type can also change the result type.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 1
8 2
9 3
Trial Expression Sample output
Record 1 =CELL("address",A7) $A$7
Record 2 =CELL("address",A8) $A$8
Record 3 =CELL("address",A9) $A$9
Microsoft Excel reference