Excel Formulas Dictionary
Master Excel with our comprehensive formula reference. Each entry includes syntax, examples, and real-world use cases.
BeginnerEssential Formulas
IF Function in Excel
Checks whether a condition is met, and returns one value if true, and another value if false.
SUM Function in Excel
Adds all the numbers in a range of cells.
COUNTIF Function in Excel
Counts the number of cells within a range that meet a single criterion.
SUMIF Function in Excel
Adds the cells specified by a given condition or criteria.
CONCATENATE Function in Excel
Joins two or more text strings into one string. (Note: Replaced by CONCAT and TEXTJOIN in newer versions).
LEFT Function in Excel
Returns the first character or characters in a text string, based on the number of characters you specify.
RIGHT Function in Excel
Returns the last character or characters in a text string, based on the number of characters you specify.
LEN Function in Excel
Returns the number of characters in a text string.
TRIM Function in Excel
Removes all spaces from text except for single spaces between words.
TODAY Function in Excel
Returns the serial number of the current date.
NOW Function in Excel
Returns the serial number of the current date and time.
AVERAGE Function in Excel
Returns the average (arithmetic mean) of the arguments.
MIN Function in Excel
Returns the smallest number in a set of values.
MAX Function in Excel
Returns the largest number in a set of values.
MEDIAN Function in Excel
Returns the median (middle value) of a set of numbers.
MODE Function in Excel
Returns the most frequently occurring value in a dataset.
AND Function in Excel
Returns TRUE if all arguments are TRUE, FALSE if any argument is FALSE.
OR Function in Excel
Returns TRUE if any argument is TRUE, FALSE if all arguments are FALSE.
NOT Function in Excel
Reverses the logic of its argument - returns TRUE if argument is FALSE, FALSE if argument is TRUE.
UPPER Function in Excel
Converts all letters in a text string to uppercase.
LOWER Function in Excel
Converts all letters in a text string to lowercase.
PROPER Function in Excel
Converts the first letter of each word to uppercase and remaining letters to lowercase.
ROUND Function in Excel
Rounds a number to a specified number of digits.
ROUNDUP Function in Excel
Rounds a number up, away from zero.
ROUNDDOWN Function in Excel
Rounds a number down, toward zero.
ABS Function in Excel
Returns the absolute value of a number (removes negative sign).
IntermediateAdvanced Techniques
VLOOKUP Function in Excel
Searches for a value in the first column of a table array and returns a value in the same row from another column.
XLOOKUP Function in Excel
A modern replacement for VLOOKUP, HLOOKUP, and LOOKUP. Searches a range or an array, and returns an item corresponding to the first match it finds.
INDEX Function in Excel
Returns the value of an element in a table or an array, selected by the row and column number indexes.
MATCH Function in Excel
Searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
TEXTJOIN Function in Excel
Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined.
MID Function in Excel
Returns a specific number of characters from a text string, starting at the position you specify.
DATEDIF Function in Excel
Calculates the number of days, months, or years between two dates.
NETWORKDAYS Function in Excel
Returns the number of whole working days between start_date and end_date.
EOMONTH Function in Excel
Returns the serial number for the last day of the month that is the indicated number of months before or after start_date.
RANK Function in Excel
Returns the rank of a number in a list of numbers.
IFERROR Function in Excel
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula.
UNIQUE Function in Excel
Returns a list of unique values in a list or range.
SORT Function in Excel
Sorts the contents of a range or array.
FILTER Function in Excel
Filters a range of data based on criteria you define.
STDEV Function in Excel
Calculates standard deviation based on a sample of a population.
VAR Function in Excel
Calculates variance based on a sample of a population.
CHOOSE Function in Excel
Returns a value from a list of values based on an index number.
XOR Function in Excel
Returns TRUE if an odd number of arguments are TRUE, FALSE if an even number are TRUE.
IFS Function in Excel
Checks multiple conditions and returns a value corresponding to the first TRUE condition.
SUBSTITUTE Function in Excel
Replaces existing text with new text in a text string.
FIND Function in Excel
Returns the position of one text string within another text string (case-sensitive).
SEARCH Function in Excel
Returns the position of one text string within another (case-insensitive, supports wildcards).
MOD Function in Excel
Returns the remainder after a number is divided by a divisor.
AdvancedPower User Tools
PMT Function in Excel
Calculates the payment for a loan based on constant payments and a constant interest rate.
FV Function in Excel
Calculates the future value of an investment based on a constant interest rate.
OFFSET Function in Excel
Returns a reference to a range that is a specified number of rows and columns from a cell or range.
Need Help with a Formula?
Our AI can write any Excel formula for you in seconds.
Try AI Formula Generator