An example of a straightforward LAMBDA function in Excel that multiplies the values in two cells. An Excel table containing various item numbers, their cost, and a blank column headed AddVAT.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Using the FV function is perfect for calculating the compound interest on an investment. Let’s break it down with a practical example. Suppose you invest $5,000 at an annual interest rate of 5% ...

Image: Andy Wolber/TechRepublic. In August 2022, Google announced support for named functions and the addition of the LAMBDA function — along with several related functions — to Google Sheets.