Excel functions / Information

CELL function

Tells you something about a cell: its address, row, column, contents, number format or the type of value in it.

Syntax

=CELL(info_type, [reference])

Arguments

When to use it

CELL reports a fact about a cell: its address, its row or column, what it holds, its number format, or the kind of value in it. The first argument says which fact, in quotes.

In Excel, CELL("filename") is the usual way to get the name of the workbook or the sheet into a cell.

Examples

  1. The address of a cell, as text

    ABCD
    1ItemPrice
    2Pen1.2$B$2

    In D2: =CELL("address", B2) → $B$2

    Try this example

  2. Whether a cell holds text or a value

    ABCD
    1ItemPrice
    2Pen1.2l

    In D2: =CELL("type", A2) → l

    l is for label (text), v for a value, b for blank.

    Try this example

  3. The row a cell is on

    ABCD
    1ItemPrice
    2Pen1.22

    In D2: =CELL("row", B2) → 2

    Try this example

Common mistakes

CELL in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try CELL in the playground

Related functions