# MAP

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value.

## Syntax

MAP (array1, lambda\_or\_array<#>)

## Argument

This function has the following arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *array1* | An array to be mapped. |
| *lambda\_or\_array<#>* | A LAMBDA which must be the last argument and which must have either a parameter for each array passed, or another array to be mapped. |

## Remarks

If an invalid LAMBDA function or an incorrect number of parameters are provided, it returns a #VALUE! error called "Incorrect Parameters".

## Data Types

Accepts an array and LAMBDA. Returns an array.

## Examples

`MAP(A1:C2, LAMBDA(a, IF(a>4,a*a,+a)))`
`MAP(TableA[Col1],TableA[Col2],LAMBDA(a,b,AND(a,b)))`

## Version Available

This function is available in product version 15 or later.