Formula Library
Excel & Google Sheets Formulas
Browse 361 practical formulas by category, search by name, or scroll A to Z.
361 formulas • Excel and Google Sheets • all on one page
Quick Formula Index
Type a formula name to search, or jump to a letter.
A
Date And Time
X
G
Add Days to a Date in Excel and Google Sheets
Adding days to a date is one of those formulas that surprises people with how simple…
→ View formula
Average
X
G
AVERAGEIF with One Condition in Excel and Google Sheets
AVERAGEIF is the conditional average function — the companion to SUMIF and COUNTIF that most people…
→ View formula
C
Percentage
X
G
Calculate a Discount in Excel and Google Sheets
Calculating discounts in a spreadsheet is one of those daily tasks that sounds trivial but has…
→ View formula
Date And Time
X
G
Calculate Age from Birthday in Excel and Google Sheets
Calculating age sounds like it should be simple — just subtract the birth date from today.…
→ View formula
Error Handling
X
G
Catch and Replace Any Error in Excel and Google Sheets
IFERROR is the formula I add to almost every formula that could possibly fail in a…
→ View formula
Text
X
G
Combine First and Last Name in Excel and Google Sheets
Combining first and last names is one of those tasks that looks trivial until you actually…
→ View formula
Financial
X
G
Compound Interest Formula in Excel and Google Sheets
Compound interest is one of those financial concepts that looks intimidating until you build it in…
→ View formula
Count
X
G
Count Blank Cells in Excel and Google Sheets
Counting blank cells is one of those checks I run on almost every dataset I open.…
→ View formula
Count
X
G
Count Cells Between Two Numbers in Excel and Google Sheets
Counting values that fall within a range — a score between 70 and 89, an amount…
→ View formula
Count
X
G
Count Cells Containing Specific Text in Excel and Google Sheets
Counting how many cells in a range contain a specific word somewhere in the text —…
→ View formula
Count
X
G
Count Cells Containing Text in Excel and Google Sheets
Counting how many cells in a column contain text — as opposed to numbers, blanks, dates,…
→ View formula
Count
X
G
Count Cells Equal to a Value in Excel and Google Sheets
Counting how many times a specific value appears in a column is one of those everyday…
→ View formula
Count
X
G
Count Cells Greater Than a Value in Excel and Google Sheets
Counting the number of values above a threshold is one of the most common analytical questions…
→ View formula
Count
X
G
Count Cells Less Than a Value in Excel and Google Sheets
Counting values below a threshold is the mirror image of counting values above one, and it…
→ View formula
Count
X
G
Count Cells Not Equal to a Value in Excel and Google Sheets
Counting cells that do not equal a specific value comes up more often than you might…
→ View formula
Count
X
G
Count Cells with Partial Text Wildcard in Excel and Google Sheets
Counting cells that match a partial text pattern — starts with a prefix, ends with a…
→ View formula
Count
X
G
Count Non-Blank Cells in Excel and Google Sheets
Counting how many cells in a range actually have something in them is one of the…
→ View formula
Count
X
G
Count Unique Values in Excel and Google Sheets
Counting unique values is a question I get asked constantly — how many distinct customers placed…
→ View formula
Count
X
G
COUNTIFS with Multiple Criteria in Excel and Google Sheets
COUNTIFS is the upgrade from COUNTIF that lets you count rows matching two or more conditions…
→ View formula
D
F
G
I
If And Logic
X
G
IF Cell Is Blank in Excel and Google Sheets
Checking whether a cell is blank is one of the most fundamental IF patterns in any…
→ View formula
If And Logic
X
G
IF Function Basic Example in Excel and Google Sheets
If I had to pick one formula that changed how I use spreadsheets, it would be…
→ View formula
If And Logic
X
G
IF with AND — Test Multiple Conditions in Excel and Google Sheets
Combining IF with AND is one of the most powerful and frequently used formula patterns in…
→ View formula
If And Logic
X
G
IF with OR Formula in Excel and Google Sheets
IF with OR is the formula for any-of-these-qualifies logic. When a result should be triggered by…
→ View formula
Lookup
X
G
INDEX MATCH Basic Example in Excel and Google Sheets
INDEX MATCH is the lookup combination that power users swear by. While VLOOKUP is simpler to…
→ View formula
M
Financial
X
G
Monthly Loan Payment Formula in Excel and Google Sheets
I built my first mortgage calculator in Excel before I knew anything about financial functions, and…
→ View formula
Date And Time
X
G
Months Between Two Dates in Excel and Google Sheets
Calculating how many months are between two dates is a question that comes up in almost…
→ View formula
N
P
R
Rank And Sort
X
G
Rank Largest to Smallest in Excel and Google Sheets
Ranking values from largest to smallest is one of the most common analytical operations in any…
→ View formula
Math
X
G
Round to 2 Decimal Places in Excel and Google Sheets
Rounding to 2 decimal places is one of the most common operations in any financial spreadsheet,…
→ View formula
S
Text
X
G
Split Full Name into First and Last Name in Excel and Google Sheets
Splitting a full name column into separate first and last name columns is one of those…
→ View formula
Sum
X
G
SUM a Column in Excel and Google Sheets
SUM is the first formula most people learn and somehow remains one of the most used…
→ View formula
Sum
X
G
Sum with Multiple Conditions using SUMIFS in Excel and Google Sheets
SUMIFS is the multi-condition version of SUMIF and one of the most useful functions in any…
→ View formula
Sum
X
G
SUMIF with One Condition in Excel and Google Sheets
SUMIF was the first formula that made me feel like I actually understood Excel. Before it,…
→ View formula
V
Lookup
X
G
VLOOKUP Basic Example in Excel and Google Sheets
VLOOKUP is the lookup formula most people learn first, and for good reason — it solves…
→ View formula
Lookup
X
G
VLOOKUP with IFERROR in Excel and Google Sheets
VLOOKUP with IFERROR is one of the first formula combinations I teach anyone who uses lookups…
→ View formula
X