X
Excel Zero to Hero Interactive Learning Platform
0%
Function Encyclopedia

Excel & DAX Formula Library

A comprehensive, searchable dictionary of 65+ Excel functions and DAX measures complete with syntax breakdowns, argument rules, and real-world analytics examples.

=AVERAGE aggregation
AVERAGE • Excel
=AVERAGEIFS aggregation
AVERAGEIFS • Excel
=COUNT aggregation
COUNT • Excel
=COUNTA aggregation
COUNTA • Excel
=COUNTBLANK aggregation
COUNTBLANK, COUNT_BLANK • Excel
=COUNTIF aggregation
COUNTIF • Excel
=COUNTIFS aggregation
COUNTIFS • Excel
=MAX aggregation
MAX • Excel
=MIN aggregation
MIN • Excel
=MOD aggregation
MOD • Excel
=POWER aggregation
POWER • Excel
=PRODUCT aggregation
PRODUCT • Excel
=QUOTIENT aggregation
QUOTIENT • Excel
=ROUND aggregation
ROUND • Excel
=ROUNDDOWN aggregation
ROUNDDOWN, Round_Down • Excel
=ROUNDUP aggregation
ROUNDUP, Round_up • Excel
=SUBTOTAL aggregation
SUBTOTAL • Excel
=SUM aggregation
SUM • Excel
=SUMIF aggregation
SUMIF • Excel
=SUMIFS aggregation
SUMIFS • Excel
CALCULATE • Excel
DIVIDE • Excel
=DATEDIF date-time
DATEDIF • Excel
=DAY date_and_time
DAY • Excel
=MONTH date_and_time
MONTH • Excel
=NETWORKDAYS.INTL date_and_time
NETWORKDAYS.INTL, NETWORKDAYS_INTL • Excel
=NETWORKDAYS date-time
NETWORKDAYS • Excel
=NOW date_and_time
NOW • Excel
=TODAY date_and_time
TODAY • Excel
=WEEKDAY date_and_time
WEEKDAY • Excel
=WEEKNUM date_and_time
WEEKNUM • Excel
=YEAR date_and_time
YEAR • Excel
=FILTER dynamic-array
FILTER • Excel 365
=SORT dynamic-array
SORT • Excel 365
=SORTBY dynamic-array
SORTBY • Excel 365
=UNIQUE dynamic-array
UNIQUE • Excel 365
=AND logical
AND • Excel
=IF logical
IF • Excel
=IFERROR logical
IFERROR • Excel
=IFNA logical
IFNA, if_NA • Excel
=IFS logical
IFS • Excel 2019
=NOT logical
NOT • Excel
=OR logical
OR • Excel
=SWITCH logical
SWITCH • Excel
=CHOOSE lookup
CHOOSE • Excel
=HLOOKUP lookup
HLOOKUP • Excel
=INDEX lookup
INDEX • Excel
=MATCH lookup
MATCH • Excel
=VLOOKUP lookup
VLOOKUP • Legacy Excel
=XLOOKUP lookup
XLOOKUP • Excel 365
=XMATCH lookup
XMATCH • Excel 365
CONCAT • Excel
=FIND text
FIND • Excel
=LEFT text
LEFT • Excel
=LEN text
LEN • Excel
LOWER • Excel
=MID text
MID • Excel
PROPER • Excel
REPLACE • Excel
RIGHT • Excel
SEARCH • Excel
SUBSTITUTE • Excel
TEXTJOIN • Excel 2019
TEXTSPLIT • Excel 365
=TRIM text
TRIM • Excel
UPPER • Excel