Function Categories
Browse all Excel & Google Sheets functions organized by category
Financial Functions
Loan payments, interest rates, investments, and depreciation calculations
Statistical Functions
Averages, standard deviations, correlations, and forecasting
Lookup & Reference Functions
Find and retrieve data across your spreadsheet with VLOOKUP, XLOOKUP, INDEX/MATCH
Date & Time Functions
Date calculations, time formatting, and duration tracking
Logical Functions
Conditional logic, branching, and decision-making in formulas
Text Functions
String manipulation, concatenation, and text formatting
Math & Trigonometry Functions
Rounding, sums, products, and mathematical operations
Database Functions
Query and aggregate data with criteria-based functions
Engineering Functions
Complex numbers, conversions, and engineering calculations
Information Functions
Check cell types, errors, and metadata about your data
Dynamic Array Functions
FILTER, SORT, UNIQUE â modern array functions for Excel 365
Google Sheets Functions
Exclusive Google Sheets functions: QUERY, IMPORTRANGE, ARRAYFORMULA