← Back to level 2
Level 2Next
CELL
A medium reference formula for returning information about a cell such as its address or formatting.
Syntax
=CELL(...)Step-by-step explanation
- 1Understand the job that CELL solves before you type the formula.
- 2Build or select the cells and ranges that CELL needs before typing it.
- 3Check the output and refine the range or criteria if needed.
Common mistakes
Expecting it to return the worksheet data itself
Using the wrong info type argument
Relying on it when a simpler formula would work
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=CELL(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =CELL(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use CELL when you need metadata about a cell rather than the cell's value.
Match against the syntax block above.