Applies a LAMBDA function to each value in the provided arrays to create a new mapped array.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MAP(array1, [array2, ...], lambda)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.
Yes, you can provide multiple arrays, provided they have the same dimensions.