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
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
Analyze Data
X
G
AVERAGE Function in Excel and Google Sheets
Calculate the arithmetic mean of a set of numbers, ignoring blank and text cells
→ View function
C
Clean Up Text
X
G
CONCATENATE Function in Excel and Google Sheets
Join two or more text strings into one combined string
→ View function
Analyze Data
X
G
COUNT Function in Excel and Google Sheets
Count the number of cells in a range that contain numeric values
→ View function
Analyze Data
X
G
COUNTA Function in Excel and Google Sheets
Count all non-blank cells in a range, regardless of whether they contain text, numbers, dates, or…
→ View function
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
E
Work With Dates
X
G
EOMONTH Function in Excel and Google Sheets
Return the last day of the month that is a specified number of months before or…
→ View function
F
Make Decisions
X
G
FALSE Function in Excel and Google Sheets
Return the boolean value FALSE
→ View function
Dynamic Arrays
X
G
FILTER Function in Excel and Google Sheets
Return all rows from a range that match a condition, spilling results dynamically
→ 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
L
Clean Up Text
X
G
LEFT Function in Excel and Google Sheets
Extract a specified number of characters from the beginning of a text string
→ View function
M
Find And Match Values
X
G
MATCH Function in Excel and Google Sheets
Find the position of a value within a range and return its row or column number
→ View function
Clean Up Text
X
G
MID Function in Excel and Google Sheets
Extract a specified number of characters from a text string starting at a given position
→ 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
P
Financial Models
X
G
PMT Function in Excel and Google Sheets
Calculate the fixed periodic payment required to fully repay a loan at a constant interest rate
→ View function
R
Clean Up Text
X
G
RIGHT Function in Excel and Google Sheets
Extract a specified number of characters from the end of a text string
→ View function
S
Dynamic Arrays
X
G
SORT Function in Excel and Google Sheets
Return a sorted copy of a range or array that spills dynamically and updates when the…
→ View function
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
Clean Up Text
X
G
TEXTJOIN Function in Excel and Google Sheets
Join multiple text strings or ranges into one string with a specified delimiter between each item
→ View function
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
U
Dynamic Arrays
X
G
UNIQUE Function in Excel and Google Sheets
Return a list of distinct values from a range, removing duplicates, as a dynamic spill result
→ 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