28 functions
Lookup & Reference
The most-used category in business Excel. Master this first if you're new.
Browse all lookup functions →Every Excel function, explained.
500+ Excel functions across 13 categories. Real examples, interactive playgrounds, downloadable workbooks, common errors and fixes. Free forever.
Sheets & Cells hosts the most complete Excel function library on the web. Whether you live in VLOOKUP as a finance analyst, are exploring dynamic arrays as a data scientist, or just learned about SUMIF yesterday, every function has its own dedicated page here.
Every page follows the same structure: syntax broken down parameter by parameter, five real-world working examples, an interactive playground, a downloadable .xlsx example workbook, common errors with plain-English fixes, and version compatibility notes. Nothing behind a paywall. No signup required.
Browse by category
200+ functions
Math & Statistics
The numeric workhorses plus statistical heavyweights for forecasting and modeling.
Browse all math functions →55 functions
Text Functions
Manipulate, split, join, clean, and extract text. Includes the 2024+ REGEX trio.
Browse all text functions →25 functions
Date & Time
Date arithmetic for birthdays, fiscal years, deadlines, and scheduling.
Browse all date functions →11 functions
Logical Functions
The decision-making core of every formula. IF, IFS, AND, OR — master conditional logic.
Browse all logical functions →20 functions
Information
Test values, catch errors early, build bulletproof formulas.
Browse all information functions →55 functions
Financial
Everything a finance modeler needs — PMT, NPV, IRR, plus bond and depreciation functions.
Browse all financial functions →5 functions
Dynamic Arrays
The 2020+ revolution in Excel — arrays that spill automatically, no Ctrl+Shift+Enter needed.
Browse dynamic array functions →14 functions
LAMBDA & Modern
Build your own Excel functions with LAMBDA. Cleaner formulas with LET. Iterate with MAP, REDUCE.
Browse LAMBDA & modern →6 functions
AI Functions (2026)
The newest generation — Excel's LLM function, Python integration, Copilot suggestions.
Browse AI functions →50 functions
Engineering
Unit conversion, base conversion, bitwise operations, complex numbers, scientific functions.
Browse engineering functions →12 functions
Database
DAVERAGE, DCOUNT, DGET — query structured tables with criteria ranges.
Browse database functions →10 functions
Cube & Web
Power Pivot and SSAS integration, plus web API functions.
Browse cube & web →What's inside every function page
- Syntax breakdown — every parameter explained in plain English, required vs optional marked
- 5 real-world examples — not toy examples, real business use cases with copy-paste formulas
- Interactive playground — test the function live in your browser, no Excel required
- Common errors and fixes — the top 3-5 problems people hit with each function
- Related functions — 5+ internal links to functions that do similar or complementary things
- Version compatibility table — Excel 365, 2021, 2019, 2016, Online, Mac, iPad
- Video tutorial — embedded YouTube walkthrough where relevant
- Downloadable .xlsx workbook — the exact examples from the page, ready to open in Excel
- FAQ section — the 5-8 questions people actually search for about each function
Frequently asked questions
Are these guides current for Excel 365 and Excel 2026?
Yes. Every function page is reviewed quarterly and updated for the latest Excel releases. Version-specific notes are included when a function behaves differently across Excel versions.
Do these functions work in Google Sheets?
Many do. About 80% of Excel functions have direct equivalents in Google Sheets, and we're expanding coverage of Sheets-specific functions through 2026. Each function page notes Sheets compatibility.
Can I use the example workbooks commercially?
Yes. Every downloadable example workbook is free to use in personal or commercial projects. Attribution appreciated but not required.
What if I can't find the function I need?
Email info@sheetsandcells.com — we add missing functions on request and prioritize the most-asked-for coverage.
Is there a downloadable master list of all 500 functions?
Yes — subscribe to our newsletter and you'll receive the complete function reference PDF as your welcome gift, alphabetized by name with one-line descriptions and category tags.
Skip the reference — let AI write the formula.
The Sheets & Cells Add-in lives inside Excel. Type what you want in plain English, get the exact working formula, insert into your cell. Free to try.
Get the Add-in →