Nine powerful new Zoho Sheet functions, including currency conversion

Nine powerful new Zoho Sheet functions, including currency conversion

Zoho Sheet is always looking for ways to make your data analysis simpler. With that in mind, we've introduced nine new functions. We believe they will help make your spreadsheets a bit more sophisticated.


 


CURRENCY  (value; from; to)

 

You'll no longer have to look up exchange rates to maintain records in different currencies. The new CURRENCY function will fetch live exchange rates and convert your numbers automatically.

 


FILTER (range; condition; [condition1]; [condition2]...)

 

While the FILTER function mimics the behavior of the traditional Filter feature, it boasts new capabilities such as being able to nest the function, perform further analysis on the filtered data without disturbing the parent data set, and add multiple filter conditions.



TEXTJOIN  (delimiter; ignore_blank; text1; text2; [text30]...)

 

TEXTJOIN lets you combine multiple ranges and independent texts dynamically. You can even specify the delimiters you want between the text entries.

 


MAXIFS   /  MINIFS  (range; criteria_range; criterion; [criteria_range1]; [criterion1]; [criteria_range2]; [criterion2]...)

 

The MAXIFS and the MINIFS functions will let you pick the maximum and minimum values, subject to specific criteria. Being able to pick the maximum and the minimum value, based on values in different criteria ranges, further expands the scope of the MAX and MIN functions.

 


UNIQUE (range)


The UNIQUE function lets you pick out all the unique entries from a range and helps you create a list with no repetitions, no matter how much duplication there is in the original data range.



XOR   (logical; [logical1]; [logical2]...)

 

XOR lets you run logical tests based on different conditions. The function returns a TRUE value if only one of the given conditions is satisfied. The result will be FALSE if neither of the conditions are satisfied or if all of the conditions are satisfied.

 


DATEDIF (start_date; end_date; unit)

 

The function not only lets you find the difference between two given dates, it also lets you choose how you want the difference to be expressed.



  IFS  (test; value; [test1]; [value1]; [test2]; [value2]...)

 

As an extension of the IF function, IFS will help you test and evaluate multiple criteria at the same time.


 

Let us know in the comments how the new functions helped you and follow us for more updates about Zoho Sheet!  




      • Sticky Posts

      • 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,

      • Check out the new Checkbox in Zoho Sheet

        Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

      • Format and analyze spreadsheet data with Zoho Sheet's Table

        While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,

      • 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

      • Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

        Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,