LAMBDA function
Summary
Create custom, reusable and call them by a friendly name
Syntax
LAMBDA([parameter1, parameter2, …,] calculation)
parameter | A value that you want to pass to the function, such as a cell reference, string or number. You can enter up to 253 parameters. This argument is optional.
calculation | The formula you want to execute and return as the result of the function. It must be the last argument and it must return a result. This argument is required.
calculation | The formula you want to execute and return as the result of the function. It must be the last argument and it must return a result. This argument is required.
Example
=LAMBDA(temp, (5/9) * (Temp-32))
=TOCELSIUS(A2)
=TOCELSIUS(A3)
=TOCELSIUS(A4)
=TOCELSIUS(A5)
=TOCELSIUS(A6)
=LAMBDA(a, b, SQRT((a^2+b^2)))
=HYPOTENUSE(A2,B2)
=HYPOTENUSE(A3,B3)
=HYPOTENUSE(A4,B4)
=HYPOTENUSE(A5,B5)
=LAMBDA(text, LEN(TRIM(text)) - LEN(SUBSTITUTE(TRIM(text), " ", "")) + 1)
=COUNTWORDS(A2)
=COUNTWORDS(A3)
=COUNTWORDS(A4)
=COUNTWORDS(A5)
=LAMBDA(year, TEXT(DATE(year, 11, CHOOSE(WEEKDAY(DATE(year, 11, 1)), 26, 25, 24, 23, 22, 28, 27)), "mm/dd/yyyy"))
=THANKSGIVINGDATE(A2)
=THANKSGIVINGDATE(A3)
=THANKSGIVINGDATE(A4)
=THANKSGIVINGDATE(A5)
=THANKSGIVINGDATE(A6)
=TOCELSIUS(A2)
=TOCELSIUS(A3)
=TOCELSIUS(A4)
=TOCELSIUS(A5)
=TOCELSIUS(A6)
=LAMBDA(a, b, SQRT((a^2+b^2)))
=HYPOTENUSE(A2,B2)
=HYPOTENUSE(A3,B3)
=HYPOTENUSE(A4,B4)
=HYPOTENUSE(A5,B5)
=LAMBDA(text, LEN(TRIM(text)) - LEN(SUBSTITUTE(TRIM(text), " ", "")) + 1)
=COUNTWORDS(A2)
=COUNTWORDS(A3)
=COUNTWORDS(A4)
=COUNTWORDS(A5)
=LAMBDA(year, TEXT(DATE(year, 11, CHOOSE(WEEKDAY(DATE(year, 11, 1)), 26, 25, 24, 23, 22, 28, 27)), "mm/dd/yyyy"))
=THANKSGIVINGDATE(A2)
=THANKSGIVINGDATE(A3)
=THANKSGIVINGDATE(A4)
=THANKSGIVINGDATE(A5)
=THANKSGIVINGDATE(A6)