Formulas Articles

The Google Sheets NOT function is a handy tool that lets you negate or reverse a logical value. This tutorial shows how to apply it in different use cases.

This tutorial shows some useful tricks and different use-cases to demonstrate how to use Google Sheets to extract numbers from strings.

The OFFSET Google Sheets function is quite an under-used function. This is mainly because a lot of people don’t understand the purpose behind the function, or how it can be effectively made use of. In

Ever tried comparing the contents of two different Google Sheets to find discrepancies? If they’re small worksheets with a few rows and columns of data, it might not be that tough. With larger amounts of

Google Sheets has been coming up with some really killer features lately, and the checkbox in Google Sheets is very useful. It’s super easy to insert a checkbox to a cell (unlike MS Excel, where

Google Sheets is a smart spreadsheet tool that has been made to be user intuitive. This means that sometimes when you enter data in Google Sheets, it will try to understand what you mean and

Sometimes, you may want a quick way to get the name of the current sheet in a cell (or a list of all the sheets in the Google Sheets documents in cells). One common scenario

Google Sheets has some kick-ass functions that can do a lot of heavy lifting. As a part of my online work, I often need to go to some websites and extract specific data points or

Those who switch from using Excel to Google Sheets often miss the fact that there is no in-built feature in Google Sheets to split cells diagonally. But if you still want to insert a diagonal