Formulas Articles

Formulas

How to Scrape Websites Using Google Sheets Formulas (Examples)

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

Formulas

How Insert Diagonal Line in Cell in Google Sheets | Split Cells Diagonally

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

How to Rename Columns in Google Sheets (2 Methods)

Giving a name to your columns can be quite useful if you want to use these in the formulas. Instead of using the column alphabet in the formula, you can instead use a better name

Formulas

How to Find Unique Values in Google Sheets (2 Easy Methods)

A big part of data analytics involves data cleaning. Well cleaned data is one that is free from incomplete, irrelevant, and redundant records. To remove redundancy, you need to get rid of duplicates, so that

Formulas

How to Calculate Percentage in Google Sheets

Expressing quantities in percentage always help give a better sense of proportion. It helps us visualize the quantity better in our heads and is great for making comparisons. It’s no wonder that most common quantities

Formulas

How to Use SORT Function in Google Sheets (Examples)

It’s always easier to work with data that has been organized and sorted in a particular order. They are easier to sift through and it’s easier to find data items of interest. This is why

Formulas

How to Use SUMIFS Function in Google Sheets (Multiple Criteria)

If you want to find the sum of values based on a condition, you most probably are aware of the SUMIF and the SUMIFS function in Google Sheets. The problem with the SUMIF function is

Formulas

How to Calculate Weighted Average in Google Sheets (Easy Formula)

Calculating the average is a common task for people working with data in Google Sheets. And when quantities in a dataset don’t carry the same amount of importance, finding simple arithmetic mean doesn’t really suffice.

Formulas

ISNUMBER Function in Google Sheets (Check if Cell Contains Number)

Google sheets provide a suite of functions called the “IS” functions. These functions are not commonly used purely on their own but are heavily used by Google Sheets experts in combination with many other functions.