LAMBDA
Create custom, reusable and call them by a friendly name.
LogicalDynamic Arrays & LAMBDALogic & ConditionsModern Excel Functions
What it does
Allows you to define a custom function using a formula, which can then be reused throughout your workbook.
Syntax
LAMBDA([parameter1, parameter2, ...], calculation)
Arguments
parameter(text) — Names of arguments to pass to the function.calculation(function) — The formula to execute.
Examples
Hypotenuse Calculator
Define a reusable function for a^2 + b^2 = c^2.
FORMULA
=LAMBDA(a, b, SQRT(a^2 + b^2))(3, 4)
RESULT
5
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | A | B |
| 2 | 3 | 4 |
Clean Text
Remove chars and trim.
FORMULA
=LAMBDA(text, TRIM(SUBSTITUTE(text, "-", "")))(" A-B-C ")RESULT
ABC
SAMPLE DATA
| A | |
|---|---|
| 1 | Raw |
| 2 | A-B-C |