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
Google Sheets VLOOKUP from another sheet is a simple way to pull data from other sources. To VLOOKUP from another sheet in Google Sheets, you can use the IMPORTRANGE function…
Don’t feel like reading? View our video tutorial for the Google Sheets FILTER function: Google Sheets has some great functions that can help slice and dice data easily. Although there…
Want to learn how to use the SUMIF function in Google Sheets? I created this guide to show exactly how to do it. While it’s easy to sum a range…
Have you come across the term, “Google Sheets INDIRECT,” but you’re unsure what it means? While Google Sheets has a myriad of functions that are pretty straightforward, the Google Sheets…
Let’s talk about how to use VLOOKUP with multiple criteria. After all, I often use this formula to find data based on more than one thing. Fortunately, there’s an easy…
The REGEXMATCH Google Sheets function is one of the most underrated functions of Google Sheets. Most users often choose not to use it as they think it will probably be…
To use IMPORTRANGE in Google Sheets, you’ll need to include the URL of the original spreadsheet and the target range you want to include in your new spreadsheet. Here’s my…
Google Sheets is a really powerful spreadsheet tool because of all the awesome formulas it has. When you enter a formula in a cell in Google Sheets and hit the…
When working with formulas in Google Sheets, testing conditions using an IF statement is quite useful. It allows you to check a condition and return a result based on whether…
When dealing with data, we often need some metrics to understand the nature of the data. Some of these metrics include the average, the mean, mode, and standard deviation. Google…
Here’s the ultimate Google Sheets formulas cheat sheet. It’s technically two documents. The first is a robust 13-page document that contains all the most common Google Sheets formulas and functions….
Google Sheets provides 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…