ExcelFlux

LAMBDA function

Create custom, reusable and call them by a friendly name.

Logical · Excel 2024+

Where can you use it?

Teams building reports and business rules. Adapt the example’s decision rule when you need to test a condition or display different results based on it.

Scenario in the workbook

Define a function that doubles a value and invoke it immediately with a value from column A.

A worked example from the workbook

RowABC
6ValuePositionReading
7123
8456
9789
Record 1
=LAMBDA(value,value*2)(A7)

Expected result2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=LAMBDA(x,x*2)(6)
Turkish Excel · tr-TR
=LAMBDA(x;x*2)(6)

Expected result

12

Worked examples

Define a function that doubles a value and invoke it immediately with a value from column A.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Value Position Reading
7 1 2 3
8 4 5 6
9 7 8 9
Case Formula Expected result
Record 1 =LAMBDA(value,value*2)(A7) 2
Record 2 =LAMBDA(value,value*2)(A8) 8
Record 3 =LAMBDA(value,value*2)(A9) 14
Microsoft Excel reference