Excel Function Categories - Browse Formulas by Type

Browse Excel functions by category including lookup, logical, text, date, financial, statistical, engineering, and more.

Start with high-traffic categories

  • [Lookup & Reference](/categories/lookup-reference/) — VLOOKUP, XLOOKUP, INDEX, MATCH
  • [Math & Trig](/categories/math-trig/) — SUMIF, SUMIFS, rounding, aggregates
  • [Logical](/categories/logical/) — IF, IFS, AND, OR
  • [Text](/categories/text/) — TRIM, TEXTJOIN, split and join
  • [Statistical](/categories/statistical/) — COUNTIF, AVERAGE, MEDIAN

How categories are organized

  • Each category page lists every function with a short description and link to the full reference.
  • Use categories when you know the task (dates, finance, text cleanup) but not the exact function name.
  • Cross-links connect to [guides](/guides/), [comparisons](/compare/), and [problem fixes](/problems/).

Browse by category

  • Lookup & Reference: Find and retrieve data from tables and ranges
  • Logical: Make decisions and test conditions
  • Math & Trig: Perform mathematical calculations
  • Statistical: Analyze data with statistical functions
  • Text: Manipulate and format text strings
  • Financial: Calculate loans, investments, and depreciation
  • Date & Time: Work with dates, times, and durations
  • Engineering: Complex numbers and engineering conversions
  • Information: Get information about cells, values, and the environment
  • Web: Retrieve data from web services and URLs
  • Database: Query data that matches criteria
  • Cube: Retrieve data from OLAP cubes and Power Pivot data models