The Google Sheets TODAY function returns the current date and time, based on the user’s computer settings. It’s a...
Spreadsheets articles
How to use the IFERROR function in Google Sheets
Instead of displaying ugly error messages, IFERROR enables you to clean up your spreadsheet and replace errors with...
How to use the IFS function in Google Sheets
The IF function in Google Sheets enables logical decision making with a simple if-else structure. It checks whether a...
How to use the SEARCH function in Google Sheets
The Google Sheets SEARCH function returns the position of a substring within a text. It is the right tool if you need...
How to use the SPLIT function in Google Sheets
The DCOUNTA formula in Google Sheets counts the number of values in a table-like array or range that meet specific...
How to use the UNIQUE function in Google Sheets
As the name suggests, the Google Sheets UNIQUE function enables you to pull out unique rows from a range, discarding...
How to use the MATCH function in Google Sheets
In Google Sheets, the MATCH function gives you the relative position of an item within a range of cells. Basically, if...
How to use the CORREL function in Google Sheets
When you're carrying out data analysis, statistical measures help you to understand underlying trends. One of the most...
How to use the IF function in Google Sheets
IF follows an else if logic and is one of the most useful Google Sheets functions. You can use it to perform logical...







