MAP Function in Excel: Syntax, Examples and Free Practice
MAP is an Excel Logic function. Applies a LAMBDA to every item in an array and returns an array of results.
MAP syntax
Arguments
array1: The first range or arraylambda: The expected rate of occurrence
When to use MAP
MAP is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice MAP online, free
Open the live Excel-style spreadsheet and try MAP yourself. No Excel install or sign-up needed to start.
Practice MAP now →More Logic functions
Frequently asked questions
What does the MAP function do in Excel?
Applies a LAMBDA to every item in an array and returns an array of results.
What is the syntax of MAP in Excel?
The syntax is =MAP(array1, lambda). array1: The first range or array; lambda: The expected rate of occurrence.
Where can I practice MAP online for free?
Open the free live spreadsheet on Cellgrids and try MAP 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