Browse by Category
From financial calculations to dynamic arrays â find the function you need
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
Google Sheets Functions
Exclusive Google Sheets functions like QUERY, IMPORTRANGE, and ARRAYFORMULA â with examples that work in both platforms.
Browse Google Sheets âFunction Comparisons
VLOOKUP vs XLOOKUP, SUMIF vs SUMIFS, IF vs IFS â clear side-by-side comparisons so you pick the right function.
View comparisons âFix Common Errors
#N/A, #VALUE!, circular references â every function page includes a troubleshooting section with real fixes.
See error fixes â