Microsoft announces a new feature that will revolutionize how you build formulas in Excel

Microsoft today announced a new feature that will revolutionize how you build formulas in Excel. Excel formulas are extremely popular, but you can’t use the formula language to define your own re-usable functions. The new LAMBDA feature will allow you to define your own custom functions using Excel’s formula language. You can also call one function from another.

Advertisements

Reusable Custom Functions

With LAMBDA, you can take any formula you’ve built in Excel and wrap it up in a LAMBDA function and give it a name (like “MYFUNCTION”). Then anywhere in your sheet, you can refer to MYFUNCTION, re-using that custom function throughout your sheet. I’ll show a couple examples below.

Recursion

Reusable functions is reason enough to start taking advantage of LAMBDA, but there’s one more thing… you can do recursion. If you create a LAMBDA called MYFUNCTION for example, you can call MYFUNCTION within the definition of MYFUNCTION. This is something that before, was only possible in Excel through script (like VBA/JavaScript). I’ll also show an example below of how you can leverage this to build things that were not possible before without writing script.

Advertisements

Syntax:

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

ArgumentDescription
parameterA 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.
calculationThe 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.

The new lambda function is available to Office Insiders on Microsoft Windows and Mac builds of Excel.

Source: Microsoft

Author: themartisboy

Technology freak ,penning personal views on tech

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.