What is LAMBDA?
Creates custom reusable functions that can be called like built-in functions.
Syntax
=LAMBDA([parameter1, parameter2, ...], calculation)
Example
Formula: =LAMBDA(x, y, x^2 + y^2)(3, 4)
Result: 25
How It Works
Creates function that calculates x² + y². Called with (3,4) returns 9+16=25.