SCAN

Progressively applies a LAMBDA function to each element in an array and returns an array of all intermediate values.

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

Syntax

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

Initial value: Optional initial value of the accumulator.

Array: The array to be scanned.

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 =SCAN(0;A2:C2;LAMBDA(a;v;a+v)) returns the array

114

147

which correspond to A2, A2+B2 and A2+B2+C2, respectively.

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