Google Sheets formulas articles

This Google Sheets SWITCH evaluates an expression against a set of specific cases. The first case to evaluate as TRUE...

The OFFSET function in Google Sheets references a range of cells that are shifted or displaced from a starting...

The SUMPRODUCT function in Google Sheets multiplies corresponding items within arrays of equal size and returns the...

Instead of displaying ugly error messages, IFERROR enables you to clean up your spreadsheet and replace errors with...

The Google Sheets SEARCH function returns the position of a substring within a text. It is the right tool if you need...

In Google Sheets, the MATCH function gives you the relative position of an item within a range of cells. Basically, if...

When you're carrying out data analysis, statistical measures help you to understand underlying trends. One of the most...

The INDIRECT function in Google Sheets takes in the cell address in the form of text and returns a cell reference. It...

The Google Sheets SORT function allows you to sort data and return the rows in ascending or descending order. It is...

The Google Sheets LOOKUP function searches through a row or column for a key and returns the value of the cell in a...

The GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google...

The INDEX function in Google Sheets returns the value of a cell within an input range, relatively separated from the...

Combining QUERY with IMPORTRANGE allows you to pull in data from different spreadsheets and perform advanced queries...

Numbers are what comes to our mind when we think of spreadsheets applications. That is no surprise because they...

While working with strings on spreadsheets, we may have to do many operations such as trimming, extracting, and...

Spreadsheets have come a long way since they were first available, thereby making our lives a lot easier. Today they...

We know we use the spreadsheets applications generally to working with numbers. But we also have a good help in terms...

Spreadsheets of today are comprehensive tools that help us with everyday calculations. Be it elementary or advanced,...

In fields including but not limited statistics, science, gaming, cryptography etc. the use or random numbers is a...

Let us say we have a range of cells in a spreadsheet, and we want to know how many columns it has spread across. If...

While there are infinite rational numbers in mathematics, we don’t usually deal with all of them. That’s because, in...

While working with spreadsheets, we tend to come across many numbers that are rational. Some of them have more decimal...

While working with spreadsheets, we are bound to do many sorts of calculations. And we will, at times need to...

Number crunching is one of the primary activities that the spreadsheets applications are built for. We all know how to...