I made a little reusable function for adding tax, and saved it in Name Manager as TaxCalc:
=LAMBDA(amount, amount*1.08)
Then in a cell I can just type:
=TaxCalc(100)
It returns 108, and I can reuse it anywhere without copying the formula around.
I am still learning this one, so what do you actually use LAMBDA for? Is it worth it for one-off calculations, or only when you reuse the same logic a lot?
I looked up what Lambda meant and why it is used for this purpose and the answer was quite interesting:
Lambda is the Greek letter λ, and the name comes from maths, not from Excel.
In the 1930s, a mathematician named Alonzo Church invented a system called lambda calculus. It was a way to describe computation using only functions, before modern computers existed.
In that system, λ was the symbol used to say "here is a function". So λx. x+1 meant "a function that takes x and returns x plus 1". The λ was just notation for "make a function".
That idea stuck in programming. In Python, JavaScript, and a lot of other languages, a "lambda" is an anonymous function, a function you define on the spot without giving it a permanent name in code.
Excel borrowed the same term. LAMBDA lets you define a function right in a formula, with parameters and a calculation, instead of writing the same logic over and over in cells. When you save it in Name Manager as TaxCalc or FACT, you are just giving that anonymous function a name so you can call it later.
So the name is a nod to Church's λ, and it basically means "a function you define here, on the fly".