In this article:

May 8, 2024

The MAP function in Google Sheets allows you to apply a specified operation to each element of a range or an array, essentially mapping one set of values to another through the operation you define.

The basic syntax of the MAP function is as follows:

**=MAP(array1, [array2, ...], lambda)**

Where:

**array1, [array2, ...]**: These are the ranges or arrays over which you want to perform the operation. You can specify multiple arrays, and the MAP function will perform the operation element-wise across these arrays.

**lambda**: This is a LAMBDA function that defines the operation to be performed on each element(s) of the specified array(s). The lambda function takes as many arguments as there are arrays specified and applies a calculation or transformation to these elements.

Below we have outlined the steps you can follow to use the MAP function in Google Sheets effectively:

Suppose you have a list of sales figures for different products in column A, and you want to apply a 10% discount to all products that have sales over $100. The original sales figures are in A2:A10, and you want the discounted prices (where applicable) to appear in B2:B10.

Here's an example:

Click on cell B2 where you want to start displaying the discounted prices. Enter the following formula:

**=MAP(A2:A10, LAMBDA(x, IF(x > 100, x*0.9, x)))**

The breakdown of the formula is as follows:

**LAMBDA(x, ...): **This introduces the lambda function where x represents each value in your specified range (A2:A10).

**IF(x > 100, x*0.9, x):** This is the condition you're applying. It checks if the value (x) is greater than $100. If it is, it multiplies the value by 0.9 (applying a 10% discount). If not, it leaves the value unchanged (x).

After typing the formula, press Enter. The results should immediately appear in B2:B10, with each applicable sales figure discounted by 10%, and figures $100 or below remaining unchanged.

If the formula doesn't work as expected, double-check each part of the lambda function for syntax errors or logical mistakes.

We hope that this article has helped you and given you a better understanding of how to use the MAP function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox

We'll email you 1-3 times a week — and never share your information.

Get your copy of our free Google Sheets automation guide!

- 27 pages of Google Sheets tips and tricks to save time
- Covers pivot tables and other advanced topics
- 100% free

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->