Use the LAMBDA function

The LAMBDA function lets you create custom functions for commonly used formulas. The function is named, and has one or more parameters up to 253 parameters, and the formula to calculate. 

=LAMBDA([parameter1, parameter2, …,] calculation)    

parameter: The value or values to pass to the function. 

calculation: The formula to execute using the parameters. Calculation must be the last argument and must return a result. 

Example: Convert Fahrenheit to Celsius

Define the following in the Name Manager:

Name: ToCelsius
Scope: Workbook
Comment: Convert a Fahrenheit temperature to Celsius
Refers to: =LAMBDA(temp, (5/9) * (temp-32))

To use: =ToCelsius(75)  

For ideas, examples, and more, see LAMBDA function.

The LAMBDA function lets you create custom functions for commonly used formulas. The function is named, and has one or more parameters up to 253 parameters, and the formula to calculate. 

=LAMBDA([parameter1, parameter2, …,] calculation)    

parameter: The value or values to pass to the function. 

calculation: The formula to execute using the parameters. Calculation must be the last argument and must return a result. 

Example: Convert Fahrenheit to Celsius

Define the following in the Name Manager:

Name: ToCelsius
Scope: Workbook
Comment: Convert a Fahrenheit temperature to Celsius
Refers to: =LAMBDA(temp, (5/9) * (temp-32))

To use: =ToCelsius(75)  

For ideas, examples, and more, see LAMBDA function.

The LAMBDA function lets you create custom functions for commonly used formulas. The function is named, and has one or more parameters up to 253 parameters, and the formula to calculate. 

=LAMBDA([parameter1, parameter2, …,] calculation)    

parameter: The value or values to pass to the function. 

calculation: The formula to execute using the parameters. Calculation must be the last argument and must return a result. 

Example: Convert Fahrenheit to Celsius

Define the following in the Name Manager:

Name: ToCelsius
Scope: Workbook
Comment: Convert a Fahrenheit temperature to Celsius
Refers to: =LAMBDA(temp, (5/9) * (temp-32))

To use: =ToCelsius(75)  

For ideas, examples, and more, see LAMBDA function.