Excel 2024: Store Complex Formula Logic in LAMBDA function


October 3, 2024 - by

Excel 2024: Store Complex Formula Logic in LAMBDA function

Excel has a great formula language with hundreds of built-in calculations, but it doesn't have functions for every possible calculation. A new research project from Microsoft's Calc Intelligence team in England will allow you to create your own functions.

The new function, LAMBDA, is available for any Microsoft 365 subscribers who opt into the Office Insiders program's Beta Channel. It's named after Princeton University mathematician Alonzo Church, who invented lambda calculus in 1936. Church was the doctoral advisor of Alan Turing, the famous mathematician who proposed the Turing machine to perform calculations long before modern computers were invented.

Imagine performing a complex calculation and passing variables to it. The variable names and logic are stored in the LAMBDA function and after testing in the worksheet you create a Name and insert the logic into name manager.

continue reading »

More Reading


Excel 2024: Use the LET Function to Re-Use Variables in a Formula

Excel 2024: Use the LET Function to Re-Use Variables in a Formula »

October 1, 2024 - by Bill Jelen


The LET function debuted during 2020 for Microsoft 365 Subscribers. There are all sorts of calculations in Excel that can benefit from re-using an intermediate calculation.

Excel 2024: Python for K-Means Clustering of Excel Data

Excel 2024: Python for K-Means Clustering of Excel Data »

September 27, 2024 - by Bill Jelen


Lately, I've been exercising every day in a Meta Quest virtual reality headset, using a game called Supernatural. There are several communities of Supernatural fans who create quests and challenges while playing Supernatural. A quick shout-out to my friends at ABSN - Adventures by Supernatural Ninjas.

Excel 2024: Using Python in Excel

Excel 2024: Using Python in Excel »

September 25, 2024 - by Bill Jelen


This article will talk about Python from an Exceller's perspective. I am definitely a Python rookie. But I found useful things that I could do with Python that I could not do in Excel.

read more articles »

Featured Products


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.


see more products »