LAMBDA
Description
Allows you to create custom, reusable functions, which can then be called by user-friendly names.
This function is useful for building functions for complex calculations and repetitive tasks thus eliminating the need to copy and paste formulas.
Syntax
LAMBDA(
parameter1_or_calculation
, [parameter2_or_calculation …]
) - parameter_or_calculation: A value that you want to pass or the formula you want to execute.