=VLOOKUP(
SUM(A1:A10)
=IF(
264+ Formulas
Interactive Playground

Excel Formula Directory

The complete searchable reference for every Excel formula. Find syntax, examples, pro tips, and test formulas live — all in one place.

100% Free 264+ Formulas No Sign-up Required Instant Search

Filter by Category

Filter by Use Case

Difficulty:
Showing 20 of 264 formulas

Download Excel Formula Cheat Sheet

Get all 264 formulas in a beautifully designed PDF. Perfect for printing — organized by category with syntax and examples.

What Are Excel Formulas?

Excel formulas are expressions that perform calculations, manipulate data, and automate tasks in Microsoft Excel spreadsheets. They always begin with an equals sign (=) and can reference cells, use operators, and call built-in functions.

From simple arithmetic like =SUM(A1:A10) to advanced lookups like =XLOOKUP(), Excel's 264+ built-in functions cover math, text manipulation, date calculations, financial modeling, statistical analysis, and more.

Most Popular Excel Formulas

  • SUM — Add numbers in a range
  • VLOOKUP / XLOOKUP — Look up values across tables
  • IF / IFS — Conditional logic and decision-making
  • COUNTIF / SUMIF — Count or sum with conditions
  • INDEX / MATCH — Flexible data retrieval
  • CONCATENATE / TEXTJOIN — Combine text strings
  • FILTER / SORT / UNIQUE — Dynamic array formulas (Excel 365)

Why Use Our Excel Formula Directory?

Our directory is designed to be the fastest way to find any Excel formula. With instant autocomplete search, interactive try-it-yourself playgrounds, categorized browsing, and a downloadable cheat sheet, it's the ultimate Excel reference tool — completely free and no sign-up required.

Frequently Asked Questions

Common questions about Excel formulas and our directory

Our directory includes 150+ Excel formulas covering all major categories: Math & Trigonometry, Text, Lookup & Reference, Logical, Statistical, Date & Time, Financial, Information, Engineering, Database, Web, and Dynamic Array formulas. We regularly update it with new formulas as Microsoft releases them.

VLOOKUP searches the first column of a range and returns from a specific column. XLOOKUP is its modern replacement (Excel 2021+/365) that can search in any direction, supports exact/approximate/wildcard matching, and has a built-in "not found" parameter. We recommend XLOOKUP for all new spreadsheets.

Yes! Each formula has an interactive "Try It" playground where you can input values and see results instantly. This works for most common formulas including math, text, and logical functions. For complex formulas that depend on Excel-specific features, we suggest trying them in a spreadsheet.

Dynamic Array formulas (FILTER, SORT, UNIQUE, SEQUENCE, etc.) are available in Excel 365 and Excel 2021+. They automatically "spill" results into multiple cells without needing Ctrl+Shift+Enter. They're a game-changer for data analysis and dynamic reporting.

INDEX/MATCH is more flexible: it can look left, handles column insertions/deletions gracefully, and works with large datasets. VLOOKUP is simpler for beginners. If you have Excel 365, use XLOOKUP instead — it combines the best of both.

The #N/A error means "Not Available" — your formula couldn't find what it was looking for. Common causes: VLOOKUP can't find a match, lookup value has extra spaces, or data types don't match (text vs number). Use IFERROR or IFNA to handle it gracefully.

SUMIFS lets you sum a range based on multiple conditions. The syntax is =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...). Each criteria pair adds an AND condition. Use wildcards (* and ?) for partial matches.

Absolutely! Our Excel Formula Cheat Sheet is completely free. It includes all 150+ formulas organized by category with syntax, descriptions, and examples. No sign-up required — just click the download button.

Search 150+ Excel formulas with syntax, examples, interactive playground, and free cheat sheet.

Tool
Excel Formula Directory
Category
All Excel tools
Availability
Browser-based tool