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
Before I get into the Google Sheet vs Excel debate, there is something you need to know. I love Excel spreadsheets, and I have been an active user for 12+…
Google Sheets has a lot of functions meant for analyzing data. FREQUENCY() is one of them. FREQUENCY() helps you count how often a given value in an array occurs within…
To find pi in Google Sheets, use the insert menu and choose the function. I’ll show exactly where to find it with screenshots and video. I’ll also discuss the mathematical…
Error handling is an important part of data processing. When you perform operations on data, errors are almost always possible. Good thing Google Sheets is well-equipped to detect these errors…
One of the most commonly used functions in Google Sheets is AVERAGE. It lets you easily get the numerical mean in a set of data. While it is a very…
The COUNTIFS in Google Sheets helps you count cells based on multiple criteria. This differs from COUNT, COUNTA, and COUNTIF. Below, I’ll explain the COUNTIFS formula. I’ll also provide a…
The GOOGLEFINANCE function is an amazing tool used to make Google Sheets stock formulas for people who need to work with real-time finance data. This single function gives you not…
You’re trying to use a simple COUNTIF function, but you get an “#ERROR!” message instead. What does it mean and how can you fix it? Google Sheets doesn’t have a…
Google Sheets QUERY is one of the most powerful functions in the GSuite universe. It’s highly versatile and can be applied to simple and complex problems. My tutorial walks you…
Not many people are familiar with the ADDRESS function since many don’t understand why they need it or how it can help. In this tutorial, we will get you familiar…
Copying and pasting cells is probably one of the first things a person learns to do when starting out with spreadsheet software like Google Sheets. However, you must have, at…
It’s hard to talk about investments and returns without visiting the topic of Internal Rate of Return, or IRR. Manually computing the IRR for a series of cash flows involves…
Discovering trends and predicting values is an essential application of financial data analysis. Google Sheets, like most spreadsheet processors, includes multiple tools for financial analytics. In fact, just for data…