CELL Function in Excel: Syntax, Examples and Free Practice
CELL is an Excel Information function. Returns information about the formatting, location, or contents of a cell.
CELL syntax
Arguments
info_type: Which piece of information to returnreference: The cell or range being referenced (optional)
When to use CELL
CELL is used to check the state or type of a cell before other formulas act on it.
Practice CELL online, free
Open the live Excel-style spreadsheet and try CELL yourself. No Excel install or sign-up needed to start.
Practice CELL now →More Information functions
Frequently asked questions
What does the CELL function do in Excel?
Returns information about the formatting, location, or contents of a cell.
What is the syntax of CELL in Excel?
The syntax is =CELL(info_type, [reference]). info_type: Which piece of information to return; reference: The cell or range being referenced (optional).
Where can I practice CELL online for free?
Open the free live spreadsheet on Cellgrids and try CELL yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Information functions · Excel case studies · Excel tutorials · Excel shortcuts