Applies a LAMBDA function to each value in the provided arrays to create a new mapped array.
Składnia
MAP(array1, [array2, ...], lambda)Argumenty
array1wymagane
The first array to be mapped.
array2opcjonalne
Additional arrays to be mapped.
lambdawymagane
A LAMBDA function that takes one or more parameters and performs a calculation.
The MAP function iterates through one or more arrays and applies a custom LAMBDA function to each element. It returns an array of the same dimensions as the input arrays, where each element is the result of the calculation performed by the LAMBDA.
=MAP({1,2,3}, LAMBDA(x, x*10))→{10, 20, 30}Multiplies each element in the array by 10.
Define the input arrays
Select the range or array of data you want to process.
Create the LAMBDA function
Write a LAMBDA function that defines how each element should be transformed.
Yes, you can provide multiple arrays, provided they have the same dimensions.