Microsoft Excel Functions

CONCATENATE

Joins several text strings into one text string

SUMIF

Adds the cells specified by a given condition or criteria

IF

Checks whether a condition is met and returns one value if TRUE and another value if FALSE

TEXTJOIN

Combines text from multiple ranges using a common delimiter you specify between each text. This function can be used as a faster way to concatenate text when there are multiple texts.

DAY, MONTH, YEAR

Converts a serial number to the day, month, or year

UPPER

Converts a text string to all uppercase letters.

PROPER

Converts a text string to proper case; the first letter of each word to uppercase, and all other letters to lowercase

LOWER

Converts all letters in a text string to lowercase

COUNTIF

Counts the number of cells within a range that meet the given condition

TODAY

Enters serial number of today's date

FIND

Finds a text value in a cell (case-sensitive)

SEARCH

Finds a text value in a cell (not case-sensitive)

AVERAGEIF

Finds average for the cells specified by a given condition or criteria

IFERROR

Returns a value you specify if a formula results in an error. If it does not result in an error, it will return the result of the formula.

MID

Returns the characters from the middle of a text string, given a starting position and length

RIGHT

Returns the specified number of characters from the end of the text string

LEFT

Returns the specified number of characters from the start of the text string

ROUNDDOWN

Rounds a number down, toward zero

ROUND

Rounds a number to a specified number of digits

ROUNDUP

Rounds a number up, away from zero

SUM

This function adds all of the values of the cells in the argument.

COUNTA

This function counts the number of cells with non-numerical data in the argument. This function is useful for quickly counting items in a cell range

COUNT

This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range

AVERAGE

This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument

MAX

This function determines the highest cell value included in the argument

MIN

This function determines the lowest cell value included in the argument

VLOOKUP

This function looks in the first column of a array to find a value, then moves across the row to return a value.