Function Reference
Excel & Google Sheets Functions
Every function explained with syntax, real examples, and Google Sheets notes.
Make Decisions Calculations Lookup Clean Text Work with Dates Analyze Data Dynamic Arrays
330 functions • Excel and Google Sheets • all on one page
1 function
Analyze Data
Count and summarize numeric data across ranges
1 function
Clean Up Text
Extract and combine and format text strings
3 functions
Do Calculations
Perform math operations including sums and rounding
0 functions
Dynamic Arrays
Return multiple results and spill into adjacent cells automatically
0 functions
Engineering & Conversion
Convert units and work with binary and hex values
0 functions
Financial Models
Calculate loan payments and investment returns and depreciation
3 functions
Find & Match Values
Search for and retrieve data from tables and ranges
0 functions
Get Information
Check cell types and test values and return metadata
2 functions
Handle Errors
Detect and trap and replace formula errors with fallback values
0 functions
Import & Web Data
Pull data from external URLs and feeds and other spreadsheets
0 functions
Lambda & Custom
Build and reuse your own custom formula logic
9 functions
Make Decisions
Test conditions and return results based on logical rules
0 functions
Statistical Analysis
Calculate probability, standard deviation, variance, and distributions
2 functions
Work with Dates
Calculate and compare and manipulate dates and times
Quick Function Index
Type a function name to search, or jump to a letter.
A
Make Decisions
X
G
AND Function in Excel and Google Sheets
Test multiple conditions and return TRUE only when all of them are true
→ View function
C
Analyze Data
X
G
COUNTIF Function in Excel and Google Sheets
Count the number of cells in a range that meet a single condition
→ View function
D
Work With Dates
X
G
DATE Function in Excel and Google Sheets
Create a date value from separate year, month, and day numbers
→ View function
F
Make Decisions
X
G
FALSE Function in Excel and Google Sheets
Return the boolean value FALSE
→ View function
I
Make Decisions
X
G
IF Function in Excel and Google Sheets
Test a condition and return one value when true and another when false
→ View function
Handle Errors
X
G
IFERROR Function in Excel and Google Sheets
Return a custom result instead of an error when a formula fails
→ View function
Handle Errors
X
G
IFNA Function in Excel and Google Sheets
Return a custom result when a formula produces a #N/A error, and the original result otherwise
→ View function
Make Decisions
X
G
IFS Function in Excel and Google Sheets
Test multiple conditions in sequence and return the result paired with the first one that is…
→ View function
Find And Match Values
X
G
INDEX Function in Excel and Google Sheets
Return the value at a specific row and column position within a range
→ View function
N
Make Decisions
X
G
NOT Function in Excel and Google Sheets
Reverse a logical value — convert TRUE to FALSE and FALSE to TRUE
→ View function
O
Make Decisions
X
G
OR Function in Excel and Google Sheets
Test multiple conditions and return TRUE when at least one of them is true
→ View function
S
Do Calculations
X
G
SUM Function in Excel and Google Sheets
Add all numeric values in one or more ranges and return the total
→ View function
Do Calculations
X
G
SUMIF Function in Excel and Google Sheets
Add only the values in a range that correspond to cells meeting a single condition
→ View function
Do Calculations
X
G
SUMIFS Function in Excel and Google Sheets
Sum values that meet two or more conditions simultaneously using AND logic
→ View function
Make Decisions
X
G
SWITCH Function in Excel and Google Sheets
Compare an expression against a list of values and return the result paired with the first…
→ View function
T
Work With Dates
X
G
TODAY Function in Excel and Google Sheets
Return the current date, recalculating automatically each time the spreadsheet opens
→ View function
Clean Up Text
X
G
TRIM Function in Excel and Google Sheets
Remove all leading, trailing, and excess internal spaces from a text string
→ View function
Make Decisions
X
G
TRUE Function in Excel and Google Sheets
Return the logical value TRUE — used in formulas that require an explicit boolean value, an…
→ View function
V
Find And Match Values
X
G
VLOOKUP Function in Excel and Google Sheets
Search the first column of a table for a value and return data from another column…
→ View function
X
Find And Match Values
X
G
XLOOKUP Function in Excel and Google Sheets
Search a column for a value and return data from a corresponding range — the modern…
→ View function
Make Decisions
X
G
XOR Function in Excel and Google Sheets
Return TRUE when an odd number of the supplied conditions are TRUE, FALSE when zero or…
→ View function
Syntax
Syntax description