Creates custom, reusable functions and calls them by a friendly name.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
LAMBDA([parameter1, ...], calculation)The LAMBDA function allows you to define a custom function that can be reused throughout your workbook. It takes one or more parameters and a calculation that uses those parameters to return a result.
=LAMBDA(x, x*1.1)(100)결과: 110
Defines a function that multiplies the input by 1.1 and immediately applies it to 100.
Yes, you can call a LAMBDA function immediately by adding parentheses with arguments at the end of the formula.