LogicalLevel: ExpertAvailable in: Excel 365 / 2021+

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))

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.

Related functions

BYROW · LAMBDA · SCAN

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.