LET, IMAGE, and two other functions to make things simpler

Zoho Sheet supports more than 400 functions to help you perform mathematical, financial, and other analytical operations. Now, we're adding four new functions to help you build spreadsheets that are more self-explanatory, more reliable, and most importantly, simpler.

1. LET

Complex levels of computation can make it difficult to read a function or troubleshoot it if it were to hit an error. LET function assigns names to calculation results and helps you handle multiple computed variables easily, all in the same function. The LET function saves a lot of time and effort and makes it easy to understand computations.

Here's an example of the LET function:

Let's say at your organization, every sales rep got 10% commission on their sales revenue and you want to calculate the net sales revenue after commission for Mark, one of your sales representatives. This is how you'd have to do it:

Without the LET function,

=SUMIF(C:C;"=Mark";G:G)-SUMIF(C:C;"=Mark";G:G)*10%

With the LET function,

=LET(revenue;SUMIF(C:C;"Mark";G:G);commission;revenue*10%;revenue-commission)

As you can see, the LET function lets you name each variable you'll have to use to calculate the revenue after commission and does not repeat calculations like in the previous version of the function, thus saving time and making the formula a lot easier to understand.

2. IMAGE

Zoho Sheet recently introduced the image in cell feature, which allows you to insert images into your cells rather than over them. You can use the =IMAGE() function to insert images into cells as well. Simply add the URL of the image you want to add and specify the mode of fit you want for the image, and you'll have the image in the formula cell! This function means the images are dynamic and will change automatically with a change made to the URL in the formula.

3. SPLIT

SPLIT is an antidote to functions like TEXTJOIN and CONCATENATE, meaning you will be able to separate a text string in one cell into different parts spread across adjacent cells in that row based on the delimiter you specify.

4. IFNA

NA is a common error that spreadsheet functions throw, and it means that there are no valid results for the formula throwing the error. For instance, a COUNTIF function set to count all cells with the value "Mark" in a range will throw an NA error if there are no cells with "Mark" in the specified range. However, an NA error does make it look like an error.

To help avoid this confusion, we introduce the IFNA function. With your functions nested inside an IFNA function, you can specify what you want displayed as the result if the nested function hits an NA error.

We hope these new functions are useful! Give them a try and let us know what you think in the comments below.

France ZUGs

Topic Participants
Selva Sundaram M

Sticky Posts
Data Validation now available in Zoho Sheet
We are glad to release the 'Data Validation' functionality in Zoho Sheet. Using this, you could restrict the data that is entered in cells to a specific condition that you set. If it is a numeric cell, you could add numeric constraints like the number should be less than 20, or between 40 and 60, etc. This could be really useful when you have a calculator like functionality on your spreadsheet and expect the input data to fall within a range. Similarly you can set rules on cells with Text and Date
Crunch your spreadsheet data better with 7 new Zoho Sheet functions
Spreadsheet functions help you quickly compute, analyze, and visualize data. Zoho Sheet supports over 400 functions, now including TOROW, TOCOL, HSTACK, VSTACK, TAKE, DROP, and NUMBERVALUE to help you reorganize data as per your convenience. TOROW With
Publish spreadsheets, sheets, or ranges with specific customizations
Publishing a spreadsheet allows you to share your reports or data with a wider audience. To expand the publishing capabilities for your spreadsheet, we've revamped the publish controls in Zoho Sheet. New look, extensive options With the new publish
Instantly locate any feature inside Sheet with Feature Finder
We count on spreadsheets to store voluminous sets of data, so we can analyze and revise them later. Zoho Sheet provides multiple features to simplify your data-related tasks. But at times, selecting the required feature to perform a desired action can
Conditional Formatting Enhancements
We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls