Complete guide to Excel and Google Sheets™ functions with examples and AI-powered explanations
Showing 351 of 351 functions
Complete Excel & Google Sheets™ Function Reference Guide
Welcome to the most comprehensive spreadsheet function reference available online. Whether you're working with Microsoft Excel, Google Sheets™, or any other spreadsheet application, this guide covers over 200 functions across 10 categories to help you master data analysis, automation, and reporting.
Why Use Spreadsheet Functions?
Spreadsheet functions are powerful tools that automate calculations, manipulate text, analyze data, and create dynamic reports. Instead of manually calculating values or copying data, functions do the work for you—saving hours of time and reducing errors. From simple SUM formulas to complex VLOOKUP and INDEX-MATCH combinations, mastering these functions transforms how you work with data.
Excel vs Google Sheets™ Compatibility
Most spreadsheet functions work identically in both Excel and Google Sheets™, but some have platform-specific variations. Our reference clearly marks which functions are supported in each platform. Functions like XLOOKUP and LAMBDA are Excel-exclusive, while GOOGLEFINANCE and IMPORTRANGE are unique to Google Sheets™. Use our compatibility badges to ensure your formulas work across platforms.
Function Categories Explained
Math & Arithmetic Functions
Essential functions for numerical calculations including SUM, AVERAGE, COUNT, ROUND, and more. These form the foundation of any spreadsheet work, from basic addition to complex statistical analysis. Learn to use SUMIF for conditional sums, SUMPRODUCT for weighted calculations, and AGGREGATE for flexible totals that ignore errors.
Text & String Functions
Manipulate and transform text data with functions like CONCATENATE, LEFT, RIGHT, MID, TRIM, and SUBSTITUTE. Perfect for cleaning imported data, extracting information from strings, and formatting text for reports. Master TEXTJOIN for combining cells with delimiters and TEXT for custom number formatting.
Lookup & Reference Functions
Find and retrieve data across your spreadsheets with VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP. These powerful functions enable database-style queries, dynamic references, and cross-sheet data retrieval. The INDEX-MATCH combination offers more flexibility than VLOOKUP, while XLOOKUP simplifies complex lookups.
Logical & Conditional Functions
Create decision-making formulas with IF, AND, OR, NOT, IFS, and SWITCH. These functions evaluate conditions and return different results based on your criteria. Nest multiple IF statements for complex logic, use IFERROR to handle errors gracefully, and leverage IFS for cleaner multi-condition formulas.
Date & Time Functions
Work with dates and times using TODAY, NOW, DATE, DATEDIF, NETWORKDAYS, and EDATE. Calculate age, find business days between dates, add months to dates, and extract year, month, or day components. Essential for project planning, scheduling, and time-based analysis.
Statistical Functions
Perform statistical analysis with STDEV, VAR, MEDIAN, MODE, PERCENTILE, CORREL, and FORECAST. From basic descriptive statistics to regression analysis and probability distributions, these functions power data science and business intelligence in spreadsheets.
Financial Functions
Calculate loans, investments, and financial metrics with PMT, FV, PV, NPV, IRR, and RATE. Whether you're building amortization schedules, analyzing investment returns, or calculating depreciation, these functions handle complex financial mathematics with ease.
Tips for Using Spreadsheet Functions Effectively
•Start simple: Master basic functions like SUM, AVERAGE, and IF before moving to complex formulas
•Use named ranges: Replace cell references like A1:A100 with descriptive names for clearer formulas
•Combine functions: Nest functions together (e.g., IF with VLOOKUP) for powerful custom solutions
•Handle errors: Wrap formulas in IFERROR to display friendly messages instead of error codes
•Use absolute references: Add $ symbols (like $A$1) to lock cell references when copying formulas
•Document your work: Add comments to complex formulas explaining their purpose
•Test incrementally: Build complex formulas step by step, testing each part
Need Help Building Formulas?
Our AI-powered Formula Generator can create custom Excel and Google Sheets™ formulas based on your description. Simply explain what you want to calculate, and get a working formula instantly—no syntax memorization required.
