Excel Function Dictionary

Search and browse 50 essential Excel functions with syntax and examples.

50 functions found

SUMMath

Adds all numbers in a range

Syntax:

SUM(number1, [number2], ...)

=SUM(A1:A10)

AVERAGEMath

Returns the average of the values

Syntax:

AVERAGE(number1, [number2], ...)

=AVERAGE(B2:B100)

ROUNDMath

Rounds a number to specified decimal places

Syntax:

ROUND(number, num_digits)

=ROUND(3.14159, 2)

ROUNDUPMath

Rounds a number up, away from zero

Syntax:

ROUNDUP(number, num_digits)

=ROUNDUP(3.14, 1)

ROUNDDOWNMath

Rounds a number down, toward zero

Syntax:

ROUNDDOWN(number, num_digits)

=ROUNDDOWN(3.99, 0)

ABSMath

Returns the absolute value of a number

Syntax:

ABS(number)

=ABS(-5)

MODMath

Returns the remainder after division

Syntax:

MOD(number, divisor)

=MOD(10, 3)

POWERMath

Returns a number raised to a power

Syntax:

POWER(number, power)

=POWER(2, 10)

SQRTMath

Returns the square root of a number

Syntax:

SQRT(number)

=SQRT(144)

SUMPRODUCTMath

Multiplies corresponding components and returns the sum

Syntax:

SUMPRODUCT(array1, [array2], ...)

=SUMPRODUCT(A2:A5, B2:B5)

COUNTStatistics

Counts cells that contain numbers

Syntax:

COUNT(value1, [value2], ...)

=COUNT(A1:A100)

COUNTAStatistics

Counts non-empty cells

Syntax:

COUNTA(value1, [value2], ...)

=COUNTA(A1:A100)

COUNTBLANKStatistics

Counts empty cells in a range

Syntax:

COUNTBLANK(range)

=COUNTBLANK(A1:A100)

COUNTIFStatistics

Counts cells that meet a condition

Syntax:

COUNTIF(range, criteria)

=COUNTIF(A:A, ">100")

COUNTIFSStatistics

Counts cells that meet multiple conditions

Syntax:

COUNTIFS(range1, criteria1, ...)

=COUNTIFS(A:A, ">10", B:B, "<100")

MAXStatistics

Returns the largest value

Syntax:

MAX(number1, [number2], ...)

=MAX(A1:A100)

MINStatistics

Returns the smallest value

Syntax:

MIN(number1, [number2], ...)

=MIN(A1:A100)

RANKStatistics

Returns the rank of a number in a list

Syntax:

RANK(number, ref, [order])

=RANK(A2, A:A, 0)

LEFTText

Extracts characters from the left of text

Syntax:

LEFT(text, [num_chars])

=LEFT("Hello", 3)

RIGHTText

Extracts characters from the right of text

Syntax:

RIGHT(text, [num_chars])

=RIGHT("Hello", 2)

MIDText

Extracts characters from the middle of text

Syntax:

MID(text, start_num, num_chars)

=MID("Hello", 2, 3)

LENText

Returns the number of characters in text

Syntax:

LEN(text)

=LEN("Hello World")

TRIMText

Removes extra spaces from text

Syntax:

TRIM(text)

=TRIM(" hello ")

UPPERText

Converts text to uppercase

Syntax:

UPPER(text)

=UPPER("hello")

LOWERText

Converts text to lowercase

Syntax:

LOWER(text)

=LOWER("HELLO")

CONCATENATEText

Joins multiple text strings into one

Syntax:

CONCATENATE(text1, text2, ...)

=CONCATENATE(A2, " ", B2)

SUBSTITUTEText

Replaces specific text within a string

Syntax:

SUBSTITUTE(text, old, new, [instance])

=SUBSTITUTE(A2, "-", "/")

TEXTText

Formats a number as text with a specified format

Syntax:

TEXT(value, format_text)

=TEXT(A2, "YYYY-MM-DD")

FINDText

Finds the position of text within a string

Syntax:

FIND(find_text, within_text, [start])

=FIND("@", A2)

VLOOKUPLookup

Looks up a value vertically and returns from a specified column

Syntax:

VLOOKUP(lookup_value, table_array, col_index, [range_lookup])

=VLOOKUP(A2, Sheet2!A:C, 3, FALSE)

HLOOKUPLookup

Looks up a value horizontally and returns from a specified row

Syntax:

HLOOKUP(lookup_value, table_array, row_index, [range_lookup])

=HLOOKUP("Name", A1:Z2, 2, FALSE)

INDEXLookup

Returns a value from a specific position in a range

Syntax:

INDEX(array, row_num, [col_num])

=INDEX(A1:C10, 3, 2)

MATCHLookup

Returns the position of a value in a range

Syntax:

MATCH(lookup_value, lookup_array, [match_type])

=MATCH("Apple", A:A, 0)

XLOOKUPLookup

Modern lookup function replacing VLOOKUP (Excel 365)

Syntax:

XLOOKUP(lookup, lookup_array, return_array, [not_found])

=XLOOKUP(A2, B:B, C:C, "Not found")

TODAYDate

Returns today's date

Syntax:

TODAY()

=TODAY()

NOWDate

Returns the current date and time

Syntax:

NOW()

=NOW()

YEARDate

Extracts the year from a date

Syntax:

YEAR(serial_number)

=YEAR(A2)

MONTHDate

Extracts the month from a date

Syntax:

MONTH(serial_number)

=MONTH(A2)

DAYDate

Extracts the day from a date

Syntax:

DAY(serial_number)

=DAY(A2)

DATEDIFDate

Calculates the difference between two dates

Syntax:

DATEDIF(start, end, unit)

=DATEDIF(A2, TODAY(), "Y")

EOMONTHDate

Returns the last day of the month

Syntax:

EOMONTH(start_date, months)

=EOMONTH(TODAY(), 0)

WEEKDAYDate

Returns the day of the week as a number

Syntax:

WEEKDAY(serial_number, [return_type])

=WEEKDAY(A2)

IFLogic

Returns different values based on a condition

Syntax:

IF(logical_test, value_if_true, value_if_false)

=IF(A2>=60, "Pass", "Fail")

IFSLogic

Evaluates multiple conditions and returns the first match

Syntax:

IFS(condition1, value1, condition2, value2, ...)

=IFS(A2>=90,"A", A2>=80,"B", TRUE,"C")

ANDLogic

Returns TRUE if all conditions are true

Syntax:

AND(logical1, [logical2], ...)

=AND(A2>0, A2<100)

ORLogic

Returns TRUE if any condition is true

Syntax:

OR(logical1, [logical2], ...)

=OR(A2="Yes", A2="OK")

IFERRORLogic

Returns a custom value if a formula results in an error

Syntax:

IFERROR(value, value_if_error)

=IFERROR(A2/B2, 0)

ISBLANKLogic

Checks whether a cell is empty

Syntax:

ISBLANK(value)

=ISBLANK(A2)

SUMIFLogic

Sums values that meet a condition

Syntax:

SUMIF(range, criteria, [sum_range])

=SUMIF(A:A, ">100", B:B)

SUMIFSLogic

Sums values that meet multiple conditions

Syntax:

SUMIFS(sum_range, range1, criteria1, ...)

=SUMIFS(C:C, A:A, "Sales", B:B, ">1000")

Excel Function Dictionary: Browse or search through 50 essential Excel functions organized by category — Math, Statistics, Text, Lookup, Date, and Logic. Each function includes syntax, description, and a ready-to-copy example. Perfect as a quick reference while working in Excel.