Excel Formula Library

Browse 200+ Excel formulas organized by category. Learn syntax, see examples, and master Excel functions.

Text Functions

Manipulate and combine text strings

CONCATENATE

Available

Combine text from multiple cells

TEXTJOIN

Available

Join text with delimiters

LEFT, RIGHT, MID

Available

Extract text from strings

CONCAT

Available

Modern version of CONCATENATE

TRIM

Available

Remove extra spaces

UPPER & LOWER

Available

Convert text case

PROPER

Available

Title case conversion

Lookup & Reference

Find and retrieve data from tables

VLOOKUP

Available

Vertical lookup in tables

VLOOKUP vs XLOOKUP

Available

Compare lookup functions

INDEX MATCH vs VLOOKUP

Available

Advanced lookup comparison

XLOOKUP

Available

Modern flexible lookup

INDEX

Available

Return value from specific position

MATCH

Available

Find position of value

HLOOKUP

Available

Horizontal lookup in tables

OFFSET

Available

Reference offset from starting cell

INDIRECT

Available

Reference specified by text

Math & Statistics

Calculate numbers and statistics

SUM

Coming Soon

Add numbers together

SUMIF

Available

Sum with conditions

SUMIFS

Available

Sum with multiple conditions

AVERAGE

Available

Calculate average

COUNT

Available

Count numbers

COUNTIF

Available

Count with conditions

COUNTIFS

Available

Count with multiple conditions

MAX, MIN

Available

Find extreme values

ROUND

Available

Round numbers

Logical Functions

Make decisions with logic

IF

Available

Basic conditional logic

IFS

Available

Multiple conditions (2019+)

IFERROR

Available

Handle errors gracefully

AND & OR

Available

Combine multiple conditions

NOT

Available

Reverse logical value

IFNA

Available

Handle #N/A errors

Date & Time

Work with dates and times

TODAY, NOW

Available

Current date and time

DATE

Available

Create date from components

YEAR, MONTH, DAY

Available

Extract date parts

DATEDIF

Available

Calculate date difference

WEEKDAY

Available

Get day of week

Dynamic Arrays (Excel 365)

Modern Excel 365 functions

FILTER

Available

Filter data by criteria

SORT

Available

Sort data automatically

UNIQUE

Available

Extract unique values

XLOOKUP Advanced

Available

Multi-criteria lookups

SORTBY

Available

Sort by another range

SEQUENCE

Available

Generate number sequences

RANDARRAY

Available

Generate random numbers

Can't Find the Formula You Need?

Use our AI Formula Generator to create any Excel formula from plain English

No credit card required • 5 free generations