Excel Formulas: Function List, Categories & Examples

Formulas & functions · Updated November 19, 2026

There is no single finite list of every Excel formula: a formula is any expression you build, while Excel’s built-in functions are a large catalog that changes by version. Below is a practical list of commonly used functions by category, plus where to find Excel’s full function catalog and how to choose the right function.

What “all Excel formulas” means

People often use “formula” and “function” to mean the same thing, but they are different. A formula is an instruction entered in a cell and normally begins with an equals sign. It can use cell references, numbers, operators, text, and functions. A function is a named operation supplied by Excel, such as SUM or IF. You can combine several functions in one formula, so the number of possible formulas is effectively unlimited even though Excel’s built-in function catalog is finite.

For example, a calculation can add two cells with the plus operator, or use SUM to total a range. Both are formulas; only the latter contains a function. Excel also includes specialized functions for statistics, engineering, finance, databases, and newer dynamic-array calculations. A list of the most familiar functions is useful as a starting point, but it should not be mistaken for every function available in every Excel release.

Common Excel functions by category

Use this categorized list as a reference when you know what you want to calculate but are unsure what function to search for. Function names below are written as they appear in English-language Excel.

  • Totals and counting: SUM, AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, COUNTBLANK, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, and AVERAGEIFS.
  • Logical tests: IF, IFS, AND, OR, NOT, SWITCH, IFERROR, and IFNA. These help return different results depending on conditions or handle certain errors.
  • Lookups and references: XLOOKUP, XMATCH, VLOOKUP, HLOOKUP, INDEX, MATCH, and CHOOSE. They locate values or return data associated with a match.
  • Text: LEFT, RIGHT, MID, LEN, TRIM, CLEAN, UPPER, LOWER, PROPER, CONCAT, TEXTJOIN, FIND, SEARCH, SUBSTITUTE, REPLACE, TEXT, and VALUE.
  • Dates and time: DATE, YEAR, MONTH, DAY, TODAY, NOW, EOMONTH, WORKDAY, and NETWORKDAYS. These create, extract, or calculate with dates and working days.
  • Math and rounding: ROUND, ROUNDUP, ROUNDDOWN, ABS, INT, MOD, RAND, RANDBETWEEN, SUBTOTAL, and AGGREGATE.
  • Statistics: STDEV.S, VAR.S, RANK.EQ, PERCENTILE.INC, and CORREL, among other functions for analyzing a sample or a data set.
  • Financial calculations: PMT, FV, PV, RATE, NPV, and IRR. These use defined assumptions and should be checked against the actual terms of a financial product or project.
  • Checking data types: ISBLANK, ISNUMBER, ISTEXT, ISERROR, and ISNA can test what a cell contains or whether a calculation returned an error.

Some names have similar purposes but different rules. COUNT counts cells containing numbers, while COUNTA counts cells that are not empty. SUMIF applies one condition; SUMIFS can apply multiple conditions. FIND and SEARCH both locate text, but FIND is case-sensitive and SEARCH is not. Reading the function’s argument description before using it can prevent subtle mistakes.

How to find Excel’s complete function catalog

In Excel for Microsoft 365 on Windows, select a cell and choose Formulas > Insert Function to open the function search dialog. Search by a word such as “date,” “average,” or “text,” or browse a category. Selecting a result displays a description and the arguments it expects. You can also start typing an equals sign and a function name in a cell; Excel’s autocomplete suggestions help identify available names and arguments.

The official Microsoft Support function reference is another way to browse the catalog. It organizes functions by category and identifies availability by Excel version. This matters when sharing a workbook: a function present in Microsoft 365 may not work in an older perpetual edition. The Insert Function dialog and Microsoft’s version notes are more reliable than an undated “all formulas” chart because function availability changes over time.

On Excel for Mac and Excel for the web, the function catalog is also available through the formula tools, although ribbon layout and keyboard shortcuts can differ from Windows. If a workbook will be opened on different platforms, check function availability and test the workbook in the recipient’s version rather than assuming every installation has the same catalog.

Examples of useful formulas

In the following examples, the cell values are specified so the results can be checked. In English-language Excel, the arguments are separated by commas. Some regional settings use semicolons as separators; if Excel rejects an otherwise valid example, check the list separator configured for that installation.

With sales amounts 120, 80, 150, and 50 in A2:A5, enter this in A6 to total them:

=SUM(A2:A5)

The result is 400, because 120 + 80 + 150 + 50 = 400.

With a test score of 72 in B2, enter this in C2 to label scores of 60 or more as Pass:

=IF(B2>=60,"Pass","Review")

The result is Pass. IF checks the condition first, then returns its second argument when the condition is true and its third when it is false.

With the statuses Paid, Pending, Paid, Paid, and Pending in A2:A6, enter this in B2 to count Paid entries:

=COUNTIF(A2:A6,"Paid")

The result is 3. COUNTIF compares each cell in the specified range with the criterion and counts matches.

With product IDs in A2:A4, corresponding product names in B2:B4, and the ID to search for in E2, enter this in F2 to return the matching name:

=XLOOKUP(E2,A2:A4,B2:B4,"Not found")

If E2 contains P-102, A3 contains P-102, and B3 contains Mug, the result is Mug. The final argument provides a readable result when there is no match, instead of an error. XLOOKUP is available in Microsoft 365 and Excel 2021 or later, not in every older Excel release.

Choosing the right function

Start with the question you need the worksheet to answer. If you need a total, use SUM; if you need a total subject to criteria, look at SUMIF or SUMIFS. For a count, distinguish between counting numbers, nonempty cells, or entries that meet a condition. For a lookup, decide whether you need an exact match, a result from a related column, or a count of matching records. This makes the search more precise than browsing a very long alphabetical list.

Compatibility is another selection factor. XLOOKUP, XMATCH, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Microsoft 365 or Excel 2021 or later. LAMBDA, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, and HSTACK require Microsoft 365 or Excel 2024. If a workbook must support older editions, use a function available in those editions or provide a version-appropriate alternative. Do not assume that a formula that works on your computer will work for every colleague.

Also consider whether the task is easier with a built-in feature than with a formula. Sorting a list once may be simpler with the Sort command, while a formula is useful when the result should update as source data changes. For repeated summaries from a changing table, a PivotTable may be clearer than a long collection of nested functions. A formula is most useful when the calculation should remain visible, repeat automatically, or feed other calculations.

Formula errors and common misconceptions

A function name is only one part of a valid formula. Check that the opening and closing parentheses match, text criteria use straight double quotes, and cell references point to the intended range. When copying a formula, relative references change position; dollar signs can lock a row or column when needed. For example, A1 changes as a formula is copied, while $A$1 remains fixed. These reference rules often explain why a formula works in its first cell but gives unexpected results elsewhere.

  • #NAME? often means Excel does not recognize a function name or text has not been put in quotation marks.
  • #N/A commonly indicates that a lookup did not find a match, though the precise cause depends on the formula.
  • #VALUE! can appear when an argument has an unsuitable data type, such as text where a calculation expects a number.
  • #DIV/0! means a calculation attempts to divide by zero or by an empty cell treated as zero.
  • Unexpected totals can result from numbers stored as text, hidden rows, an incorrect range, or criteria that do not match the data exactly.

IFERROR can return an alternative value when a formula produces an error, but it should not be used to conceal a problem before understanding it. For instance, a lookup returning “Not found” may be appropriate when missing IDs are normal; hiding every error as a blank can make damaged references or bad source data harder to notice. If a formula appears as text instead of calculating, check whether the cell is formatted as Text and whether the entry begins with an equals sign.

Building a reliable formula list for your workbook

A personal reference sheet is often more useful than trying to memorize the entire catalog. Record the task, function name, expected inputs, an example, and the Excel versions that support it. Keep examples tied to realistic cell layouts, and note whether a formula expects dates as actual Excel date values rather than text that merely looks like a date. For shared workbooks, include a short note explaining unusual criteria or assumptions.

Use descriptive table headers and structured references when working with Excel tables, so a formula is easier to read and can expand as the table grows. Keep calculation steps visible when that improves review: a few clear helper columns are often safer to maintain than one deeply nested formula. Before replacing a working formula with a newer function, consider who will open the workbook and whether they have a compatible version.

Frequently Asked Questions

Does Excel have one complete list of every formula?
Excel has a built-in catalog of functions, but not a finite catalog of every possible formula, because users can combine functions, references, and operators in countless ways. Use Formulas > Insert Function or Microsoft’s function reference to browse built-in functions.

How many formulas are there in Excel?
There is no fixed count of formulas, since a formula is something a user constructs. Excel offers hundreds of built-in functions, and the available set depends on the release. Microsoft’s current function reference is the best place to check the catalog for a particular version.

What is the difference between a formula and a function?
A formula is a cell expression that starts with an equals sign; a function is a named calculation that may appear inside it. A formula can use a function, an operator, or both.

Where can I see which functions my Excel version supports?
Search in Formulas > Insert Function, then check the Microsoft Support function reference for version notes. If you receive a workbook from someone using a newer Excel version, test it in the edition that will be used to open it.

Why does Excel show a function name as invalid?
Check the spelling, the opening equals sign, quotation marks around text, and argument separators. The function may also be unavailable in your Excel version, or your regional settings may require a different argument separator.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.