SCAN Function in Excel: Syntax, Examples and Free Practice
SCAN is an Excel Logic function. Applies a LAMBDA to an array and returns each intermediate accumulated value.
SCAN syntax
Arguments
initial_value: The starting value before the calculation begins (optional)array: The range or array to evaluatelambda: The expected rate of occurrence
When to use SCAN
SCAN is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice SCAN online, free
Open the live Excel-style spreadsheet and try SCAN yourself. No Excel install or sign-up needed to start.
Practice SCAN now →More Logic functions
Frequently asked questions
What does the SCAN function do in Excel?
Applies a LAMBDA to an array and returns each intermediate accumulated value.
What is the syntax of SCAN in Excel?
The syntax is =SCAN([initial_value], array, lambda). initial_value: The starting value before the calculation begins (optional); array: The range or array to evaluate; lambda: The expected rate of occurrence.
Where can I practice SCAN online for free?
Open the free live spreadsheet on Cellgrids and try SCAN yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts