Spreadsheet Formulas: Google Sheets and Excel

Functions are the engine inside the cells of your spreadsheet. They power all your most important operations.

Whether you’re calculating compound interest, concatenating cells, or projecting financial expectations, you’ll need to use formulas in Google Sheets and Excel.

Here, we’ll talk about how they work. Our team of experts includes data analysts, programmers, and financial wonks.

Use our search function to look for any specific formula you want to explore, or read on for some of the most popular Google Sheets formulas we’ve ever covered.

Popular Formulas in Google Sheets

We already mentioned a few powerful built-in formulas. The most common might be using a spreadsheet to calculate compound interest.

The same formulas also allow financial planners to project potential investment growth for retirement investments.

We use similar spreadsheet formulas for linear regression, which is helpful for predicting all sorts of financial situations.

Of course, many formulas are so ubiquitous they can’t be confined to a single category. You might need to concatenate cells for all sorts of imported data.

Understanding Syntax

We cover the syntax of Google Sheets and Excel functions in every one of our articles. That means we’ll break down any formula with an equals sign.

In our article on the IF CONTAINS formula, you’ll see this:

=REGEXMATCH(text, expression)

Then, we break down what that means. The first term is the name of the function. The terms in parenthesis are arguments for the formula.

Those vary based on the Google Sheets function, so we give examples for exactly what you need.

Spreadsheet Formula Examples

We also include step-by-step instructions on how to use each formula. That’s true for Google Sheets and Excel functions.

Read my guide to ISERROR, for example. I give a complete guide on how to use it to highlight rows with errors. The guide also includes instructions on how to modify the formula to check for errors in multiple rows or across your whole spreadsheet.

Spreadsheet Formula Cheat Sheet

Looking for quick answers in a single PDF? We wrote a popular Google Sheets Formulas Cheat Sheet. You can download it for free.

How-To Videos

Our team of spreadsheet experts regularly makes videos on complex formulas. Check out our YouTube channel.

Recently, we’ve covered VLOOKUP, SPLIT, and the COUNTIF formula.

Find a Specific Formula

Sometimes, I need to select more than one item in a drop-down list in my spreadsheet. It’s not a built-in function. So how do you do it? I’ll show you how to make multiple selection drop-d...
To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....
Adding a Google Sheets hyperlink is easy. Follow this guide to learn 3 different ways to do it in asa little as a few seconds....
To import Stock Prices into Google Sheets, use the File menu and select import. Then, upload your CSV file. Here’s a video I made that shows the whole process. Where to Find Historical Stock Pri...
Sometimes, I need to select more than one item in a drop-down list in my spreadsheet. It’s not a built-in function. So how do you do it? I’ll show you how to make multiple selection drop-d...
Looking for a timestamp Google Sheets tutorial? From keyboard shortcuts to formulas, discover everything you need about these quick hacks! ...
Find out how to jump to a cell or range in Google Sheets. My guide shows two ways to do this, including a keyboard shortcut....
This tutorial covers how to lock cells in Google Sheets with several step-by-step examples including options for mobile devices....
Using Google Sheets images is simple. But, there are a lot of ways to insert images into a cell. Check this guide for 5 easy ways to put images into Sheets....
Learn how to freeze a row in Google Sheets which can help be a lot more efficient when working with large datasets. This works for columns too....
While you can't permanently change the font in Sheets, you can learn how to use the Google Sheets' change default font option with these three easy methods....
To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....
Can Google Sheets group rows and columns? Yes, there are actually a few different ways to do it. Learn them all here....
To compare two columns in Google Sheets, use a function like COUNTIF or VLOOKUP. Here's how to use spreadsheet functions for comparison....
Have you been asking, "How to add time in Google Sheets?" It can be done in a number of ways. This guide covers easy ways, giving you the perfect solution....
To count cells with text in Google Sheets, use one of these three functions. My guide includes a video guide (including searching for partial text)....