MAP

Results in an array where each cell is computed by applying a formula to the corresponding cells of one or more input arrays.

ປ້ອນສູດເປັນ ສູດອາເຣ (array formula). ຄຳແນະນຳ: ປ້ອນສູດໂດຍໃຊ້ປຸ່ມ Ctrl + Shift + Enter.

ໄວຍາກອນ

=MAP(Array1 [; Array2 [;...]; Formula)

Array1 [; Array2 [;...]: The arrays that provides the arguments to the formula.

Formula: An expression defined by a LAMBDA function or similar, which processes the data from the provided array(s). If multiple arrays are supplied, their corresponding cells are passed as arguments to the formula or function. The formula or function must accept as many parameters as there are arrays. It must be the final argument of the MAP function.

If the arrays have different dimensions, the MAP function returns an array of size M × N, where M is the maximum number of rows across all arrays, and N is the maximum number of columns. Any extra cells in the resulting array that are not processed by the formula are filled with #N/A.

ຕົວຢ່າງ

ຂໍ້ມູນຕໍ່ໄປນີ້ຈະຖືກໃຊ້ເປັນຕົວຢ່າງ

	A	B	C
1	ຄະນິດສາດ	ຟີຊິກ	ຊີວະສາດ
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

The formula =MAP(A2:C13;LAMBDA(var;var*3)) returns an array of same dimensions where each element of the source array is multiplied by 3.

ຂໍ້ມູນທາງເຕັກນິກ

This function is available since LibreOfficeDev 27.2.

ຟັງຊັນນີ້ ບໍ່ແມ່ນ ສ່ວນໜຶ່ງຂອງມາດຕະຖານ Open Document Format for Office Applications (OpenDocument) ເວີຊັນ 1.3 ພາກທີ 4: ຮູບແບບສູດທີ່ຄິດໄລ່ຄືນໃໝ່ (OpenFormula). ຊື່ພື້ນທີ່ (name space) ແມ່ນ

COM.MICROSOFT.MAP