MAP

The MAP function maps each value in an array to a new value determined by a LAMBDA function, and returns a new array.

MAP(array, array…, LAMBDA(parameter, calculation))

array: The array to be mapped.

array…: An additional input array.

LAMBDA: A defined subformula.

parameter: An input that defines the value you are passing through the formula.

calculation: The formula you want the function to execute and return. This is required and must be the last argument.

Notes

Example

Given the following table:

A

B

C

1

1

2

3

2

4

5

6

=MAP(A1:C2, LAMBDA(parameter, parameter^2)) returns the array below.

A

B

C

1

1

4

9

2

16

25

36

See alsoLAMBDALAMBDA.APPLYREDUCE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
உதவியாக இருந்ததா?
எழுத்தின் அளவு: 250
அதிகபட்ச எழுத்தின் அளவு: 250
உங்கள் கருத்திற்கு நன்றி.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.