# 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

### How to Zoom Out in Google Sheets and Zoom Back In [Easy]

Sometimes you need to be able to view more of your sheet at once. This guide will teach you to how to zoom out in Google Sheets and to zoom in when you're done....

### How to Make Multiple Selection in Drop-down Lists in Google Sheets

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...

### How To Highlight Duplicates in Google Sheets

To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....

### How to Insert a Google Sheets Hyperlink in 5 Seconds

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....

### How to Make Multiple Selection in Drop-down Lists in Google Sheets

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...

### A Simple Timestamp Google Sheets Tutorial for 2024

Looking for a timestamp Google Sheets tutorial? From keyboard shortcuts to formulas, discover everything you need about these quick hacks! ...

### The Easiest Way to Jump to a Cell or Range in Google Sheets

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....

### 5 Simple Ways to Insert Google Sheets Images

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....

### How To Lock Cells in Google Sheets (Easy 7 Min Guide)

This tutorial covers how to lock cells in Google Sheets with several step-by-step examples including options for mobile devices....

### How to Freeze a Row in Google Sheets, Columns Too! [Easy]

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....

### How To Use the Google Sheets’ Change Default Font Function (3 Easy Ways)

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....

### How To Highlight Duplicates in Google Sheets

To highlight duplicates in Google Sheets, use conditional formatting and the UNIQUE function. This guide includes step-by-step instructions....

### A Simple Google Sheets Compare Two Columns Guide for 2024

To compare two columns in Google Sheets, use a function like COUNTIF or VLOOKUP. Here's how to use spreadsheet functions for comparison....

### Can Google Sheets Group Rows and Columns? Yes, Here’s How

Can Google Sheets group rows and columns? Yes, there are actually a few different ways to do it. Learn them all here....

### How To Add Time in Google Sheets [4+ Easy Ways]

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....

### An Easy Google Sheets Count Cells with Text Guide for 2024

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)....