Formulas and Functions
The MAP function maps each value in an array to a new value determined by a LAMBDA function and returns a new array.
MAP(array, array…, LAMBDA(element, calculation))
array: The array to be mapped.
array…: An additional input array.
LAMBDA: A defined subformula.
element: An input that defines the value you are passing through the formula.
calculation: The formula you want the function to execute and return. This is required and must be the last argument.
Given the following table: |
=MAP(A1:C2, LAMBDA(element, element^2)) returns the array below.
Please don’t include any personal information in your comment.
Maximum character limit is 250.
Thanks for your feedback.
English (US) ·