LogicalLevel: ExpertAvailable in: Excel 365 / 2021+
In this article
- Syntax
- Examples
- Example 1
- Related functions
MAP applies a LAMBDA to every item of one or more arrays and returns an array of results.
Syntax
=MAP(array1, [array2, ...], LAMBDA(a, [b], calculation))
| Argument |
What it means |
LAMBDA |
Receives one item from each array. |
Examples
Example 1
=MAP(A2:A100, B2:B100, LAMBDA(q, r, IF(q>100, q*r*0.9, q*r)))
Line amounts with a 10% discount on large quantities.
BYROW · LAMBDA · SCAN
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong