REDUCE

Applies a custom LAMBDA function to each element in a given array and accumulates results to a single value.

Syntax

=REDUCE([Initial value]; Array; Formula)

Initial value: Optional initial value of the accumulator.

Array: The array to be reduced.

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

The LAMBDA function requires two variables: an accumulator (e.g., a) and the array element value (v), and must be structured as follows:

LAMBDA (a, v, a + f (v))

where f(v) is a function of the individual cells of the array.

Mga halimbawa

Halimbawa

Ang sumusunod na data ay gagamitin bilang halimbawa

	A	B	C
1	Math	Physics	Biology
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 =REDUCE(100000;A2:A13;LAMBDA(a;v; a + v*v)) returns 120715, which is 100000 added to the sum of the squares of the Math column.

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.REDUCE