Returns a calculated array of a specified row and column size by applying a LAMBDA function.
Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.
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))Resultat: {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.