Excel formulas list: 501+ functions with practice
Every Excel function with its syntax, arguments and an example, plus a free live spreadsheet to practice it. Pick a formula to learn it, then solve it online.
â Math & Trig formulas
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
- ROUND
- ROUNDUP
- ROUNDDOWN
- ABS
- POWER
- SQRT
- MOD
- INT
- TRUNC
- CEILING
- FLOOR
- PRODUCT
- RAND
- RANDBETWEEN
- PI
- GCD
- LCM
- SUBTOTAL
- SIN
- COS
- TAN
- ASIN
- ACOS
- ATAN
- ATAN2
- SINH
- COSH
- TANH
- DEGREES
- RADIANS
- EXP
- LN
- LOG
- LOG10
- SQRTPI
- FACT
- FACTDOUBLE
- MULTINOMIAL
- MDETERM
- MMULT
- MINVERSE
- MUNIT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- SIGN
- ODD
- EVEN
- CEILING.MATH
- FLOOR.MATH
- CEILING.PRECISE
- FLOOR.PRECISE
- ISO.CEILING
- QUOTIENT
- SERIESSUM
- SEQUENCE
- RANDARRAY
- ARABIC
- ROMAN
- BASE
- DECIMAL
- SUMPRODUCT (conditional sum, array-style)
- SUMIF using an INDEX+MATCH range
- MAX + IF (array formula)
- MIN + IF (array formula)
- SUMPRODUCT + COUNTIF (count matches from a list)
- SUMIFS with OR logic (multiple SUMs)
- SUM + OFFSET (dynamic range sum)
- SUMIFS with an INDEX+MATCH dynamic column
đ¤ Text formulas
- CONCATENATE
- CONCAT
- TEXTJOIN
- LEFT
- RIGHT
- MID
- LEN
- TRIM
- UPPER
- LOWER
- PROPER
- SUBSTITUTE
- REPLACE
- FIND
- SEARCH
- TEXT
- VALUE
- EXACT
- REPT
- TEXTBEFORE
- TEXTAFTER
- TEXTSPLIT
- ARRAYTOTEXT
- VALUETOTEXT
- NUMBERVALUE
- DOLLAR
- FIXED
- T
- CLEAN
- UNICHAR
- UNICODE
- ASC
- BAHTTEXT
- LEFTB
- RIGHTB
- MIDB
- LENB
- FINDB
- SEARCHB
- REPLACEB
- DBCS
- CONCATENATE + IF
- LEFT + FIND
- RIGHT + FIND
- MID + FIND
- TRIM + SUBSTITUTE
- TEXTJOIN + IF (conditional join)
- LEN + SUBSTITUTE (count occurrences)
- PROPER + TRIM (name cleanup)
- Nested SUBSTITUTE (multiple replacements)
⥠Logic formulas
đ Date & Time formulas
- TODAY
- NOW
- DATE
- DATEDIF
- DAY
- MONTH
- YEAR
- WEEKDAY
- WEEKNUM
- EOMONTH
- EDATE
- NETWORKDAYS
- WORKDAY
- TIME
- HOUR
- ISOWEEKNUM
- DATEVALUE
- TIMEVALUE
- DAYS
- DAYS360
- YEARFRAC
- NETWORKDAYS.INTL
- WORKDAY.INTL
- MINUTE
- SECOND
- DATEDIF + TODAY
- EOMONTH + TODAY
- NETWORKDAYS + IF
- WEEKDAY + IF (weekend check)
- YEAR + MONTH (period key)
đ Statistical formulas
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- MAX
- MIN
- MAXIFS
- MINIFS
- MEDIAN
- MODE
- STDEV
- VAR
- RANK
- LARGE
- SMALL
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- T.DIST
- T.INV
- CHISQ.DIST
- CHISQ.INV
- F.DIST
- F.INV
- BETA.DIST
- BETA.INV
- GAMMA.DIST
- GAMMA.INV
- BINOM.DIST
- BINOM.INV
- POISSON.DIST
- WEIBULL.DIST
- EXPON.DIST
- HYPGEOM.DIST
- LOGNORM.DIST
- LOGNORM.INV
- NEGBINOM.DIST
- CONFIDENCE.NORM
- CONFIDENCE.T
- PERCENTILE.INC
- PERCENTILE.EXC
- QUARTILE.INC
- QUARTILE.EXC
- RANK.EQ
- RANK.AVG
- STDEV.S
- STDEV.P
- VAR.S
- VAR.P
- COVARIANCE.P
- COVARIANCE.S
- CORREL
- PEARSON
- RSQ
- SLOPE
- INTERCEPT
- FORECAST.LINEAR
- TREND
- GROWTH
- LINEST
- LOGEST
- GEOMEAN
- HARMEAN
- TRIMMEAN
- SKEW
- SKEW.P
- KURT
- DEVSQ
- AVEDEV
- MODE.SNGL
- MODE.MULT
- FREQUENCY
- PERMUT
- PERMUTATIONA
- COMBIN
- COMBINA
- FISHER
- FISHERINV
- STANDARDIZE
- PROB
- CHISQ.TEST
- T.TEST
- F.TEST
- Z.TEST
- T.DIST.2T
- T.DIST.RT
- CHISQ.DIST.RT
- F.DIST.RT
- F.INV.RT
- CHISQ.INV.RT
- GAMMA
- GAMMALN
- GAMMALN.PRECISE
- PHI
- AVERAGEA
- MAXA
- MINA
- STDEVA
- STDEVPA
- VARA
- VARPA
- RANK + IF (conditional rank)
- COUNTIFS with OR logic (multiple SUMs)
- AVERAGE + IFERROR
- Two COUNTIFs multiplied (AND workaround)
- COUNTIF + ISNUMBER (data quality check)
đ° Financial formulas
- PMT
- FV
- PV
- NPV
- IRR
- RATE
- NPER
- IPMT
- PPMT
- CUMIPMT
- CUMPRINC
- SYD
- DDB
- VDB
- MIRR
- XNPV
- XIRR
- PRICE
- YIELD
- DURATION
- MDURATION
- ACCRINT
- ACCRINTM
- DISC
- INTRATE
- RECEIVED
- PRICEDISC
- PRICEMAT
- YIELDDISC
- YIELDMAT
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- DOLLARDE
- DOLLARFR
- EFFECT
- NOMINAL
- FVSCHEDULE
- PDURATION
- RRI
- ISPMT
âšī¸ Information formulas
đī¸ Database formulas
âī¸ Engineering formulas
- BIN2DEC
- BIN2HEX
- BIN2OCT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- HEX2BIN
- HEX2DEC
- HEX2OCT
- OCT2BIN
- OCT2DEC
- OCT2HEX
- COMPLEX
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- CONVERT
- DELTA
- GESTEP
- ERF
- ERFC
- BESSELJ
- BESSELY
- BESSELI
- BESSELK
- ERF.PRECISE
- ERFC.PRECISE
đ Web formulas
đ§ Cube formulas
đ°ī¸ Compatibility formulas
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
- HYPGEOMDIST
- LOGINV
- LOGNORMDIST
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTRANK
- POISSON
- TDIST
- TINV
- WEIBULL
- ZTEST
đ Lookup & Reference formulas
- VLOOKUP
- HLOOKUP
- XLOOKUP
- INDEX
- MATCH
- CHOOSE
- INDIRECT
- OFFSET
- ADDRESS
- ROW
- COLUMN
- ROWS
- COLUMNS
- TRANSPOSE
- LOOKUP
- FILTER
- SORT
- UNIQUE
- HYPERLINK
- GETPIVOTDATA
- AREAS
- FORMULATEXT
- XMATCH
- TAKE
- DROP
- EXPAND
- HSTACK
- VSTACK
- TOCOL
- TOROW
- CHOOSEROWS
- CHOOSECOLS
- RTD
- INDEX + MATCH
- VLOOKUP + IFERROR
- INDEX + MATCH (2-way lookup)
- INDEX + MATCH + IFERROR
- VLOOKUP + MATCH (dynamic column)
- XLOOKUP + IFNA
- INDEX + MATCH (multiple criteria)
- HLOOKUP + MATCH (dynamic row)
- INDEX + MATCH + MAX (find the top item)
- INDEX + MATCH + MIN (find the bottom item)
- INDEX + SMALL + IF (nth match, array formula)
- VLOOKUP + CHOOSE (reversed lookup)
- INDEX + MATCH with wildcards
- VLOOKUP + ROW (fill down variant)
- INDEX + OFFSET + MATCH (dynamic lookup range)
- INDIRECT + MATCH (dynamic sheet reference)
Logical formulas
- IF + AND
- Nested IF
- Nested IF (3 levels)
- IF + AND + OR (combined)
- IFS + AND
- IF + ISERROR
- IF + ISBLANK
- IF + OR
- IF + ISNUMBER
- IF + TODAY
- IF + VLOOKUP (conditional lookup)
- Nested IF + VLOOKUP (tiered lookup)
- IF + LEN (input validation)
- VLOOKUP + ISERROR (existence check)
Browse by category
- Math and Trig functions
- Text functions
- Logic functions
- Date and Time functions
- Statistical functions
- Financial functions
- Information functions
- Database functions
- Engineering functions
- Web functions
- Cube functions
- Compatibility functions
- Lookup and Reference functions
- Logical functions
Excel formulas cheat sheet · Excel exercises · Start Excel practice · Excel case studies · Interview prep