Arrow left
Back to guides
Google Sheets Formulas

How to Use LAMBDA Function in Google Sheets

In this article, you will learn what the LAMBDA formula is and how to use it.

What is the LAMBDA formula in Google Sheets?

The LAMBDA formula was introduced by Google in late August 2022. The function helps to create a customized formula with placeholders of values used in the formula.

You can also share the customized formula with other collaborators by using the Named Function, which also became available in Google Sheets at the same time.

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

How to use the LAMBDA formula in Google Sheets

  • Type “=LAMBDA” or go to “Insert”“Function” “Logical” → “LAMBDA”.

  • Determine, “name”, “formula_expression”, and “value”.

  • The formula returns the value computed by the formula you defined with the “value” input.

How to insert the LAMBDA formula from the menu bar in Google Sheets

The generic formula of the LAMBDA is as follows:

=LAMBDA([name, …], formula_expression)(value,...)

Name: You define the names of the placeholders for values (including texts, numbers, and, dates, etc.)  that you incorporate in “formula_expression”. You can define them as much as you need by inserting commas between each of them.

Formula_expression: This is the part where you determine a formula including the placeholders defined in “Name” works. You need to define how each placeholder is processed, combined with general formulas such as “IF”.

Value: This is the actual value used when the formula defined in “formula_expression” runs its computation. The number of “values” should correspond to that of “name”. If you have more than one value, they can be punctuated by comma(s).

See the examples below. In these examples, the LAMBDA formula contains only one variable.

How to use the LAMBDA with a variable in Google Sheets

Example #1: In this example, “w” is a placeholder for an input value. As the value of cell C3 is 10, the formula returns 25 (=10+15=w+15).

Example #2: Similar to Example #1, “x” is a placeholder for an input value. As the value of cell C4 is 20, the formula returns 40 (=(20 multiplied 20) divided by 10=(x*x)/10). Another important point is that a placeholder can be referred repeatedly in the formula.

Examples #3 and #4: You can use other formulas when you determine the customized formula in the LAMBDA function. Here, we use the “IF” function. In this case, “y” is a placeholder for an actual value. The LAMBDA returns 30 when the input is cell C5 of 30 and gives you 90 when the input is cell C6 of 40, according to the IF formula contained.

Sheets tutorials availalble now in our free certificate program!
Learn basic and intermediate functions with digestible videos and instructions.
Enroll in LiveFlow Academy

Example #5: This example shows that a placeholder is not necessarily a single lowercase letter. You can use any word such as “Item” as a placeholder, too.

Examples #6 and #7: As you can see, you can include a text or a date in the “formula_expression” section. A placeholder need not be surrounded by quotations.

Examples #8: As shown in the screenshot, if you define “x” as a placeholder and if you use a different letter or word in the “formula_expression” part, the LAMBDA function won’t work. You need to refer to the defined placeholder name(s) in that part.

Next, see the examples below with two variables.

How to use the LAMBDA with two variables in Google Sheets

Examples #9 to #11: These are the examples where you have two input values. Remember to punctuate two inputs with a comma. 

Example #12: This is to show that you can incorporate a formula(s) as an input value. Apart from other examples shown, one of the values for this formula is SUM(C13:16)=100, and the other is SUM(D13:D16)=260. 100 corresponds to the placeholder of “ItemA” and 260 is tied to another placeholder of “ItemB”.

Finally, see the following examples with three placeholders.

How to use the LAMBDA with three variables in Google Sheets

Examples #13 to #15: As the number of placeholders increases, the “formula_expression” looks more complicated, compared to the LAMBDA formulas with one or two variables. So, it is important to make the names of the placeholders as clear and simple as much as possible (e.g., giving them short and different names, etc.). Also, you should be careful about the correspondence of placeholders and values you input.

The examples you looked at in the screenshots are relatively simple and easy and you might think you don’t need to create a customized formula for them. However, as you saw various types of inputs in the LAMBDA formula here, you are ready to create a complicated customized formula when needed.

How to save a customized formula you created in Google Sheets

Read this article: How to Use Named Function in Google Sheets to learn how to register and share your own formulas.

The world's top businesses trust LiveFlow to automate their financial reporting
We turn Quickbooks Online data into a live FP&A dashboard in Sheets FAST!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below