If you’re a Zoho Sheet user, you’d be thrilled to learn how your Spreadsheet experience just got better! That’s right, Zoho Sheet just became more powerful with these two new functionalities that make complex sheet functions simpler: Array Formulas and Named Expressions. In addition to these features, we have also enhanced our STOCK() formula.
Here’s an overview of these helpful new additions:
Have you ever tried finding cells matching a particular pattern in your spreadsheet? Such as, finding the average of numbers that are greater than zero within a range of cells?
An array formula is a formula that does just that; perform multiple calculations on one or more items in an array. So you can do things which are generally not possible through the regular formulas.
For example, the Stock Portfolio spreadsheet embedded below uses Array formulas to fetch the ‘current price’ and ‘% change’ from Yahoo Finance. Learn more about how you can use
Named Expressions / Dynamic Named Ranges
Named Expressions are similar to Named Ranges except that instead of referring to a static cell, they refer to a formula. They can be used 1) to create dynamic ranges – ranges that grow as you add new data and 2) to simplify your formulas by replacing oft-repeated expressions with a named expression.
Learn more about Named Expressions.
STOCK Function Enhancement
We have enhanced our STOCK() function, which is used to get stock details of a particular symbol. You can now pass a cell reference as an argument, eg: =STOCK(B6;”Price”). You can use this function in a nested formula. The behavior is now similar to a regular function.