# THE LAMBDA FUNCTION

Available in Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web

## Kubicle Function Rating:

This function is a powerful one, but it’s power is entirely related to the user’s imagination!

## SYNTAX:

=LAMBDA (parameter, …, calculation)

## ARGUMENTS:

• Parameter = An input for the function
• Calculation = The calculation to perform as the result of the function.

## DESCRIPTION:

The LAMBDA function is used to create custom, reusable functions and label them by names defined by the workbook user.  The LAMBDA function is available for use only within a single workbook (i.e. they cannot be used across multiple excel workbook files).

## EXAMPLES:

1 – Create a reusable function which converts Fahrenheit to Celsius

2 – Create a function to calculate compound annual growth rate

3 – Create a function to calculate number of days until the end of quarter

## HOW TO CREATE YOUR FIRST LAMBDA FUNCTION:

1. Define your first LAMBDA function using Name Manager:
Formulas > Name Manager and click on New (macOS: Formulas > Define Name).

1. Define your formula using the following:
• Name: FtoC
• Refers to: =LAMBDA(x,((x-32)*(5/9))