Returns a calculated array of a specified row and column size by applying a LAMBDA function.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MAKEARRAY(rows, cols, lambda)The MAKEARRAY function creates a new array with the dimensions you specify. It uses a LAMBDA function to calculate each element based on its row and column index.
=MAKEARRAY(2, 2, LAMBDA(r, c, r*c))결과: {1, 2; 2, 4}
Creates a 2x2 array where each cell value is the product of its row and column index.
Yes, the LAMBDA function can return text, numbers, or even other arrays.