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.
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!
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!
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!
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!
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.