SCAN function

The SCAN function is used to search an array (range) and return the calculated value based on a formula specified using the LAMBDA function. The first, optional argument, is the initial value. It is often left out. Then we specify an array (range) and at the end we state the mentioned expression by which the calculation is performed. The result of this function is not one value but a range whose dimensions correspond to a given sequence.

The syntax of this function is:

SCAN ([<initial value>], <array>, <calculation>)

And the easiest way to see how it works is on the example of calculating the factorials of a given range of numbers. The formula you need to enter is:

=SCAN(,A1:C2,LAMBDA(x,y,x*y))

The result is a series of factorials that correspond to a given sequence.