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.

Many of our articles also have their own videos. We post most of them on our YouTube channel, too.

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.

Find a Specific Formula

To calculate age in Google Sheets, use the DATEDIF or YEARFRAC formulas. Follow along for screenshots and full formula explanations....
To hide gridlines in Google Sheets, use the view menu or the print menu. This guide shows both (and how to add or remove lines in specific cells)....
To make a Google Sheet drop down list, use the insert menu or right click. This guide also covers data validation in drop downs menus and Excel....
Learn how to make a single-color, multi-color, and Geo Google Sheets heat map in a few clicks with this comprehensive step-by-step guide....

How-To Videos

Our team of spreadsheet experts regularly makes videos on complex formulas.

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

The main purpose of drop-down lists in Google Sheets is to offer options that a user can choose from. It gives users a clear look at all the available options and also makes sure the user selects only...
Looking for a timestamp Google Sheets tutorial? From keyboard shortcuts to formulas, discover everything you need about these quick hacks! ...
There's a special function to help you use VLOOKUP from another sheet in Google Sheets and Excel. This guide includes screenshots....
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....
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 compare two columns in Google Sheets, use a function like COUNTIF or VLOOKUP. Here's how to use spreadsheet functions for comparison....