Perform customized calculations with the new LAMBDA functions!

Perform customized calculations with the new LAMBDA functions!

We released the LAMBDA function in Zoho Sheet in 2021, enabling customized calculations inside predefined functions. Now, we're extending LAMBDA's capabilities with six new functions. Each of these functions applies LAMBDA to the given input, performs a predefined action, and returns the result.
 

1. MAP()

Performs the LAMBDA calculation on each value in the given array(s), and returns an array as the result.
 
Try it out with the embedded range below!



2. REDUCE()

Performs the LAMBDA calculation on each value in the given array and returns the single accumulated value as the result.
 
Try it out with the embedded range below!


 

3. SCAN()

Performs the LAMBDA calculation on each value in the given array, and returns a result array of the same size as the input array.
 
Try it out with the embedded range below!


 

4. MAKEARRAY()

Performs the LAMBDA calculation on the given array and returns an array with a specified number of rows and columns.
 
Try it out with the embedded range below!


 

5. BYROW() and BYCOL()

Perform the LAMBDA calculation on the given array either by column or row, and return the result in the form of rows (BYCOL) or columns (BYROW). These functions can also be used in combination with other predefined functions, like SUM and MAX.
 
Try it out with the embedded range below!


 
Try out the new LAMBDA functions in your spreadsheets and share your feedback in the comment section. Looking for ways to create full-fledged custom functions in Zoho Sheet? Click here to learn how!

Besides the new LAMBDA functions, we've also introduced nine new Text and Spreadsheet functions to Zoho Sheet. Learn more about them here.


 
Join the Zoho Sheet community and stay updated on the latest features, interact with fellow users, and learn from the team behind Zoho Sheet.

    • Sticky Posts

    • New Features: Repeat Last Action, Insert Cut/Copied Rows/Columns and Hyperlink

      You might have noticed the constant updates to Zoho Sheet of late. Here are 3 more features that have been added to Zoho Sheet recently: F4 - Repeat Last Action Insert Cut/Copied Rows and Columns Insert Hyperlink Here is a screen cast demonstrating each of these features. Read further below to learn more about these new features. F4 - Repeat Last Action: You can now repeat the last action you made on your spreadsheet by using the keyboard shortcut, F4. It is quite handy and helps you get your work
    • What's new in Zoho Sheet: Simplify data entry and collaboration

      Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementally
    • Introducing Forms in Zoho Sheet

      We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
    • Slicers are now available in Zoho Sheet—filter your data interactively

      At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
    • Introducing Data Bars: Graphically represent changes in data within the cells

      Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method