Excel Formula Library

Excel Formula Examples: Copy-Paste Formulas, Tips, and Steps

Browse practical Excel formula examples by category, with plain-English explanations, syntax, copy-paste examples, step-by-step notes, and common mistakes.

150+ formula pagesExamples firstReadable formulas

💡 Ideas for You

Helpful learning resources for Excel formulas.

4 useful links
📚 Step-by-step booksBeginner-friendly learning resources from Create & Learn.📘 Formula guideBooks and references for math Excel formulas.🧮 Formula cheat sheetsQuick references for common spreadsheet formulas.📊 Reporting guidesResources for turning formula results into useful reports.

Learn formulas by doing, not by reading theory only

This library is designed for people who need a working Excel answer quickly. Each page starts with the formula, explains what it means, gives real copy-paste examples, and points out the mistakes that usually confuse beginners.

Browse by category

Start with the category that matches your task. Each category gives you a focused list of formulas, and each formula page shows examples one at a time so long formulas stay readable.

15 examples

Logical

Decision formulas for yes/no checks, pass/fail labels, approvals, exceptions, and multi-condition reports.

Includes AND, CHOOSE, FALSE, IF →21 examples

Lookup & Dynamic Arrays

Find values, return matching records, filter lists, sort results, stack ranges, and create dynamic reports.

Includes CHOOSECOLS, CHOOSEROWS, DROP, FILTER →29 examples

Text

Clean names, split text, combine columns, remove extra spaces, extract IDs, and prepare messy data for reports.

Includes CLEAN, Combine First and Last Name, CONCAT, CONCATENATE →19 examples

Date & Time

Calculate due dates, ages, business days, month ends, week numbers, durations, and date-based reporting periods.

Includes Convert Text Dates, DATE, DATEDIF, DAY →21 examples

Math

Sum values, round numbers, calculate totals, build running totals, generate sequences, and control numeric output.

Includes ABS, AGGREGATE, CEILING, FLOOR →16 examples

Financial

Calculate payments, interest, investment returns, margins, ROI, NPV, IRR, CAGR, and loan schedules.

Includes Break-Even, CAGR, FV, Gross Margin →20 examples

Statistics

Count records, average values, rank results, find percentiles, calculate variation, and summarize datasets.

Includes AVERAGE, AVERAGEIF, AVERAGEIFS, COUNT →9 examples

Data Cleaning

Fix messy imports, remove unwanted characters, clean phone numbers, detect duplicates, and validate input.

Includes Clean Phone Numbers, Conditional Formatting Formula, Convert Numbers Stored as Text, Data Validation List →

Popular Excel formula examples

These are good starting points for most spreadsheet users.

IF formulaXLOOKUP formulaVLOOKUP formulaSUMIFS formulaCOUNTIFS formulaFILTER formulaTEXTJOIN formulaTODAY formulaPMT formulaGross Margin formulaTRIM formulaUNIQUE formulaDATEDIF formulaINDEX MATCH formula

How to use these pages

  1. Open the formula page closest to your task.
  2. Copy the beginner example first and test it with your own cells.
  3. Read the common mistakes before applying it to a full workbook.
  4. Move to the intermediate or advanced examples only after the basic version works.