LAMBDA Function in Excel: Syntax, Examples & Practice
Learn the Excel LAMBDA function: Creates a reusable custom worksheet function that can be called with inputs. Try focused practice and download a free workbook.
Syntax
=LAMBDA([parameter1, parameter2, …], calculation)
Requires Microsoft 365 or Excel 2024 on desktop. Perpetual Excel 2021 does not include this function. Check your platform and update channel before using it.
Worked example
| Row | A: Parameter | B: Value |
|---|---|---|
| 2 | Input | 25 |
| 3 | Multiplier | 2 |
=LAMBDA(x,x*2)(B2)
Expected result: 50
The reusable calculation doubles its parameter; invoking it with B2 returns 50.
Professional use
Reusable business rules, custom calculations and modern formula design.
Practice LAMBDA · Download practice .xlsx
Apply your skills
Explore MIS and finance projects
Questions and answers
How can I practise LAMBDA?
Use the focused ten-question LAMBDA lab, then download its workbook for ten additional function-specific tasks and an answer key. Core learning works without an account.
Which Excel version supports LAMBDA?
Requires Microsoft 365 or Excel 2024 on desktop. Perpetual Excel 2021 does not include this function. Check your platform and update channel before using it.
Does the browser simulator replace Microsoft Excel?
No. It supports a selected set of formula behavior for practice. Native workbook recalculation, full function compatibility, PivotTables and external data features must be checked in your own Excel installation.
Interactive practice runs in your browser.