Google Sheets formulas articles

If you’re looking to calculate the value of your investments in the future, then the FV formula in Google Sheets is...

Nowadays, long-term payments are becoming more and more popular in both personal and professional environments....

There are scenarios when using Google Sheets where we may need a tool to negate a logical value or expression. The NOT...

If you’re managing the returns of your periodic cash flows in Google Sheets, then using the IRR formula can not only...

When dealing with data in spreadsheets, having dates and times in string format is commonplace. While they convey the...

The IMPORTXML Google Sheets function lets you import data from structured data types like HTML and XML. It also...

Google Sheets is a great tool for data analysis tasks. Oftentimes, a key part of this involves statistical analysis,...

Google Sheets is a great tool to perform financial calculations and analysis with. A typical example of this is that...

You can use spreadsheets not only for number crunching but for operating with text-based data as well. Google Sheets...

If you want a quick way to analyze your spreadsheet data visually without building full charts, the SPARKLINE function...

The VLOOKUP Google Sheets function is perhaps one of the most widely used functions in Google Sheets. It stands for...

The HLOOKUP function is perhaps not as famous and widely used as its counterpart, VLOOKUP function. However, the two...

The FILTER function in Google Sheets helps you filter and return rows in a range that meet specified criteria. You can...

The EOMONTH function in Google Sheets stands for “End Of MONTH“, and rightly so. It returns the last calendar date of...

The ADDRESS Google Sheets function returns a cell’s address in the form of a text. It is noteworthy that the resulting...

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