Excel Function Dictionary

Excel has a vast array of functions that can be used to perform various calculations and manipulations on data. Here’s a breakdown of some of the most commonly used functions, categorized by their purpose:

Examples of each category

Mathematical and Trigonometric Functions

• SUM: Adds all numbers in a range of cells.
• AVERAGE: Calculates the average (mean) of a range of cells.
• COUNT: Counts the number of cells in a range that contain numbers.
• MAX: Returns the largest number in a range of cells.
• MIN: Returns the smallest number in a range of cells.

Statistical Functions

• STDEV: Calculates the standard deviation of a sample.
• VAR: Calculates the variance of a sample.
• CORREL: Calculates the correlation coefficient between two data sets.

Text Functions

• CONCATENATE: Combines text strings from different cells.
• LEN: Returns the length of a text string.

Date and Time Functions

• TODAY: Returns the current date.

Logical Functions

• IF: Performs a logical test and returns one value if the test is true, and another value if the test is false.
• AND, OR, NOT: Performs logical operations on multiple conditions.

Lookup and Reference Functions

• VLOOKUP: Looks up a value in a table and returns a corresponding value from a specified column.
• HLOOKUP: Similar to VLOOKUP, but looks up values horizontally.
• INDEX: Returns a value from a specified cell in a range.
• MATCH: Returns the relative position of an item in a range.