MAKEARRAY

Creates an array of the specified dimensions, with each cell's value is generated by applying a formula.

Ilagay ang formula bilang isang array formula . Hint: ipasok ang formula gamit ang mga key Ctrl + Shift + Enter .

Syntax

=MAKEARRAY(nRows; nCols; Formula)

nRows: the number of rows of the resulting array.

nCols: the number of columns of the resulting array.

Formula: a formula expression or LAMBDA function that will be called on each cell of the array.

The formula must define 2 variables, related to the rows and columns of the array.

Mga halimbawa

The formula =MAKEARRAY(5;5;LAMBDA(r;c;IF(r=c;1;0))) creates a 5x5 identity matrix (it is the same result of the function =MUNIT(5)).

The formula =MAKEARRAY(5;8;(LAMBDA(r;c;"@@@"))) creates a 5x8 array filled with the string "@@@".

The formula =MAKEARRAY(1;7;LAMBDA(r;c;c)) creates a one row array filled with numbers 1 to 7.

Teknikal na impormasyon

This function is available since LibreOfficeDev 27.2.

Ang function na ito ay HINDI bahagi ng Buksan ang Format ng Dokumento para sa Mga Aplikasyon sa Opisina (OpenDocument) Bersyon 1.3. Bahagi 4: Recalculated Formula (OpenFormula) Format pamantayan. Ang name space ay

COM.MICROSOFT.MAKEARRAY

BYCOL

MAP

MAKEARRAY wiki page.