SCAN

This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value.

Syntax

SCAN([initial_value], array, lambda(accumulator, value, body))

Argument	Description
[initial_value]	[Optional] Sets the starting value for the accumulator.
array	[Required] An array to be scanned.
lambda	[Required] A LAMBDA that is called to reduce the array. The LAMBDA takes three parameters: accumulator The value totaled up and returned as the final result. value The current value from the array. body The calculation applied to each element in the array.

Argument

Description

[initial_value]

[Optional] Sets the starting value for the accumulator.

array

[Required] An array to be scanned.

lambda

[Required] A LAMBDA that is called to reduce the array. The LAMBDA takes three parameters:

SCAN(1, A1:C2, LAMBDA(a,b,a*b))