190+ Most Used Excel Functions List by Category

70 Most Popular & Common Excel Functions by Alphabetical Order

Function Name	Objective
AND	Checks whether all the arguments are TRUE, and returns TRUE if all arguments are TRUE.
AVERAGE	Returns the average (arithmetic mean) of its arguments, which can be numbers or names, arrays, or references that contain numbers.
AVERAGEIF	Finds average for the cells specified by a given condition or criterion.
AVERAGEIFS	Returns the average of the cells of an array that satisfy one or more given criteria.
CHOOSE	Chooses a value or action to perform from a list of values, based on an index number.
COLUMN	Returns the column number of a cell reference.
COLUMNS	Checks the number of columns in an array or reference and returns the number in digits.
CONCATENATE	Joins two or more text values or numbers into one single text value.
CORREL	Calculates the correlation coefficient of two cell ranges.
COUNT	Counts the number of cells in a range that contains numbers.
COUNTA	Counts the number of cells in a range that is not empty.
COUNTIF	Counts the number of cells within a range that meets the given condition.
DATE	Creates a date from numeric values in the arguments.
DATEDIF	Determines how many days, months, or years there are between two dates.
DAY	Returns the day of a date as a number between 1 and 31.
FILTER	Filters cells or values according to requirements.
FIND	Returns the starting position of a case-sensitive text string within another text string.
FLOOR	Rounds a number down to the nearest multiple of significance.
FORECAST	Predicts or calculates a future value with a linear trend.
FREQUENCY	Returns how often numeric values occurred within the ranges you specify in a bin table of a set of data or dataset.
HLOOKUP	Searches for a value in the top row of a table or array of values and returns the value in the same column from the specified row.
IF	Checks whether a condition is met, and returns one value if TRUE, and another if FALSE.
IFS	Takes multiple conditions and values and returns the corresponding value to the first TRUE.
INDIRECT	Stores data from the reference specified by a text string.
INT	Rounds a decimal number down to the lowest integer portion.
IRR	Calculates the internal rate of return.
ISNA	Checks whether a value is #N/A, and returns TRUE or FALSE.
LARGE	Returns the K-th largest value in a dataset where K must be a positive integer.
LEFT	Finds the several characters of a text beginning from the left according to the number you provide.
LEN	Reflects the length of text as a number.
LINEST	Finds the least-squares method to compute the statistics for a straight line and returns an array describing that line.
LOOKUP	Looks up a value in the one-row or one-column range.
MATCH	Returns the lookup value’s relative position.
MAX	Returns the largest value in a set of values. Ignores logical values and text.
MID	Returns a specific number of characters from the middle of a string, given a specific starting position.
MIN	Extracts the lowest or smallest value from a range of cells or cell references.
MOD	Returns the remainder after a number is divided by a divisor.
MODE	Returns the most frequently occurring, or repetitive, value in an array or a range of data.
NOT	Always returns a logically opposite value.
OFFSET	Starts off from a particular cell reference, moves to a specific number of rows down, then to a specific number of columns right, and then extracts out a section from the data set having a specific height and width.
OR	Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.
PMT	Calculates the payment for a loan based on a constant interest rate.
POWER	Returns a number raised to a power.
PRODUCT	Calculates the multiplication among numbers in Excel.
PROPER	Converts a text string into the proper case; the first letter in each word to uppercase, and all other letters to lowercase.
PV	Calculates the present value of a loan or investment.
RANK	Returns the position of a given number in a given list of other numbers.
RATE	Calculates the rate of interest.
REPLACE	Replaces a part of a text string with a different text string.
REPT	Repeats text a given number of times.
RIGHT	Extract a specified number of characters from a given string from right to left.
ROUND	Rounds a number based on the provided number of digits.
ROUNDUP	Rounds a number up, away from zero.
ROW	Returns the row number for a given cell reference.
SEARCH	Returns the number of characters after finding a specific character or text string, reading from left to right.
SMALL	Finds the k-th (generally what we know as nth) smallest value in a data set.
SORT	Sorts a given range of cells according to a specific row or column in ascending or descending order.
SUM	Adds all the numbers in each range of cells.
SUMIF	Adds the cells specified by a given condition or criteria.
SUMIFS	Add the cells given by specified conditions or criteria.
SUMPRODUCT	Takes one or more arrays as an argument, multiplies the corresponding values of all the arrays, and then returns the sum of the products.
TEXT	Converts a value to text in a specific number format.
TODAY	Returns the current date formatted as a date.
TRANSPOSE	Converts a vertical range of cells to a horizontal range or vice versa.
TREND	Calculates the values of a given set of X and Y and returns additional Y-values by using the least square method based on a new set of X-values along with a linear trend line.
TRIM	Removes extra spaces from a text string.
UNIQUE	Returns a list of unique values in a range or in a list.
VALUE	Converts a text string that represents a number to a number.
VLOOKUP	Looks for a given value in the leftmost column of a given table and then returns a value in the same row from a specified column.
WEEKDAY	Returns the day of the week for a given argument.

Excel Database Functions

In Excel, database functions are a set of specialized functions that enable you to perform calculations and analysis on data stored in a database format. These functions are designed to work specifically with lists or tables of data that are structured in a consistent manner.

Function Name	Objective
DCOUNT	Counts the cells that contain numbers in a field (column) of records in a list or database that fit the requirements that we define.
DCOUNTA	Enumerates the number of non-empty cells in a given database based on criteria.
DMIN	Determines the minimum value for a field or column based on user-specified criteria.
DPRODUCT	Returns the product of a defined field from a database that matches specified criteria.
DSTDEV	Calculates the standard deviation of a population based on a sample of data.
DSTDEVP	Determines the standard deviation of a population based on the entire population by using the number or name of the heading in a column of the dataset that matches the conditions that are mentioned.
DSUM	Calculates the total sum of a specific Field by matching specific Criteria from a given Range.
DVAR	Obtains sample variance for matching records.

Excel Date & Time Functions

The date and time functions are useful for tasks such as calculating durations, extracting specific components from dates or times, formatting date and time values, and more.

Function Name	Objective
DATE	Creates a date from numeric values in the arguments.
DATEDIF	Returns the difference of days, months or years between two dates.
DATEVALUE	Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code.
DAY	Returns the day of a date as a number between 1 and 31. This function is used for extracting a day number from a date.
DAYS	Returns the number of days between two dates.
EDATE	Provides a date according to the month number given in the argument.
EOMONTH	Returns a string of numbers that represent the last day of the month before or after a specified number of months.
HOUR	Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).
MINUTE	Returns the number of minutes in a given time value.
MONTH	Gets the month, as a number from 1 (January) to 12 (December).
NETWORKDAYS	Returns the number of whole workdays between two dates.
NETWORKDAYS.INTL	Returns the number of whole workdays between 2 dates with custom weekend parameters.
NOW	Returns the current date and time formatted as a date and time.
SECOND	Extracts seconds from different types of time input.
TIME	Returns the decimal number for an individual time.
TIMEVALUE	Converts a text time to an Excel serial number for a time, a number from 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM).
TODAY	Returns the current date formatted as a date.
WEEKDAY	Returns a number from 1 to 7 identifying the day of the week to a given date.
WEEKNUM	Calculates the week number of a date.
WORKDAY	Returns a date that is a working day in the future or the past.
WORKDAY.INTL	Returns the serial number of the date before or after a specified number of weekdays with custom weekend parameters.
YEAR	Calculates a year number from a date and it returns a 4-digit year of the corresponding date.
YEARFRAC	Calculates the fraction of the year represented by the number of whole days between two dates.

Excel Engineering Functions

The engineering functions can be used to solve specific engineering problems, perform conversions between different number systems, and handle complex calculations that are common in scientific and technical fields.

Function Name	Objective
COMPLEX	Combines real and imaginary components together into complex values.
CONVERT	Converts a number from one measurement system to another.
IMDIV	Returns the result after dividing a complex number by another complex number.
IMAGINARY	Extracts the imaginary coefficient from the corresponding complex number in Excel.
IMPRODUCT	Returns the product of complex numbers, up to a maximum of 255 numbers.
IMSUM	Returns the sum of two or multiple complex numbers in Excel.

Excel Financial Functions

Financial functions perform various calculations, such as determining loan payments, calculating interest, analyzing investment returns, and more.

Function Name	Objective
DB	Determines the depreciation cost of an asset in each period of time over its lifetime.
EFFECT	Returns an effective annual interest rate based on the nominal interest rate and the number of compounding periods per year.
FV	Calculates the future value of an investment.
IPMT	Returns the interest payment for a given period for an investment, based on periodic constant payments and a constant interest rate.
IRR	Calculates the internal rate of return.
MIRR	Considers both the finance and reinvest rates to calculate the modified internal rate of return.
NOMINAL	Returns the nominal annual interest rate.
NPER	Calculates the total number of periods over which the loan is fixed with a constant interest rate.
NPV	Calculates the net present value (NPV) of an investment using a discount rate and a series of future cash flows.
PDURATION	Calculates the number of periods required for an investment to reach a designated future value at a constant interest rate.
PMT	Returns the number of loan payments required as a number.
PPMT	Returns principal payments for a given period.
PRICE	Calculates the breakeven price per $100 face value of a bond or security.
PV	Calculates the present value of a loan or investment.
RATE	Calculates the rate of interest.
RRI	Returns an equivalent interest rate for the growth of an investment over a certain period.
SLN	Returns the straight-line depreciation of an asset for one period.
XIRR	Calculates the internal rate of return (IRR) for a series of cash flows.
YIELD	Calculates the yield that pays interest on purchased bonds or security on a regular basis.

Excel Information Functions

These functions are useful for conditional formatting, data validation, or creating formulas that depend on specific cell characteristics.

Function Name	Objective
CELL	Returns information about a cell color, file name, contents, format, row, etc.
ISBLANK	Evaluates if the cell is blank.
ISERROR	Indicates any error value.
ISEVEN	Determines if a number is even.
ISLOGICAL	Checks if a cell contains any boolean or logical values.
ISNA	Checks whether a value is #N/A, and returns TRUE or FALSE.
ISNUMBER	Check whether a value is a number or not.
ISODD	Determines if a number is odd.
ISTEXT	Checks whether a value is text or not.
N	Returns a value converted to a number.
SHEETS	Counts the number of sheets.
TYPE	Returns an integer number that represents the type of the selected data.

Excel Logical Functions

These functions are used to perform logical comparisons, make decisions, and test conditions within formulas or logical statements.

Function Name	Objective
AND	Checks whether all the arguments are TRUE, and returns TRUE if all arguments are TRUE.
FALSE	Returns the word FALSE to make remarks or compare with others.
IF	Checks whether a condition is met, and returns one value if TRUE, and another one if FALSE.
IFERROR	Generates a custom value as a result if there is any error from the formula.
IFNA	Tackles the #N/A error.
IFS	Takes multiple conditions and values and returns the corresponding value to the first TRUE.
NOT	Returns a logically opposite value.
OR	Checks whether any arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments are FALSE.
SWITCH	Compares or evaluates a given expression which is a value against a list of values and returns a result corresponding to the first match found.
TRUE	Returns the logical value TRUE based on a condition.
XOR	Performs an exclusive OR function.

Excel Lookup & Reference Functions

These functions allow you to search for values, match data across multiple ranges, and extract information from different parts of your spreadsheet.

Function Name	Objective
ADDRESS	Creates a cell reference as text within specified row and column numbers.
CHOOSE	Chooses a value or action to perform from a list of values, based on an index number.
COLUMN	Returns the column number of a cell reference.
COLUMNS	Returns the column count in a given reference.
FILTER	Filters cells or values according to requirements.
FORMULATEXT	Returns the used formula as a string.
HLOOKUP	Searches for a value in the top row of a table or array of values and returns the value in the same column from the specified row.
HYPERLINK	Brings out a cutoff link that will open on a server, or links to other worksheets.
INDEX	Returns a value or reference of the cell at the intersection of a particular row and column in a given range.
INDIRECT	Stores data from the reference specified by a text string.
LOOKUP	Looks up a value in the one-row or one-column range.
MATCH	Returns the lookup value’s relative position.
OFFSET	Starts off from a particular cell reference, moves to a specific number of rows down, then to a specific number of columns right, and then extracts out a section from the data set having a specific height and width.
ROW	Returns the row number for a given reference.
ROWS	Returns the number of rows in a reference or array.
SORT	Sorts a given range of cells according to a specific row or column in ascending or descending order.
TRANSPOSE	Converts a vertical range of cells to a horizontal range or vice versa.
UNIQUE	Returns a list or array of unique values.
VLOOKUP	Looks for a given value in the leftmost column of a given table and then returns a value in the same row from a specified column.
XLOOKUP	Searches a range or an array for a match and returns the corresponding item from a second range or array.

Excel Math & Trig Functions

These functions allow you to perform calculations involving numbers, angles, and geometric operations.

Function Name	Objective
ABS	Returns the absolute value of a number.
AGGREGATE	Is used on different functions like AVERAGE, COUNT, MAX, MIN, SUM, PRODUCT, etc., with the option to ignore hidden rows and error values to get certain results.
CEILING	Rounds up a number to its nearest upper integer or to the multiple of significance.
COMBIN	Determines the total possible number of combinations for a given number of items without any repetition in Excel.
COS	Determines the cosine of angles in Excel.
EVEN	Rounds any number to a nearly even integer number.
EXP	Calculates and returns the value of the constant e raised to the power of a given number.
FACT	Returns the factorial of a number.
FLOOR	Rounds a number down to the nearest multiple of significance.
INT	Rounds a decimal value down to the lowest integer portion.
LN	Calculates the natural logarithm of a number.
LOG	Returns the logarithm of a number to the base you specify.
MMULT	Multiplies two arrays of numbers and returns another array of numbers.
MOD	Returns the remainder after a number is divided by a divisor.
ODD	Rounds up or down a number to the nearest odd integer.
PI	Returns the value of Pi, 3.14159265358979, accurate to 15 digits.
POWER	Returns a number raised to a power.
PRODUCT	Calculates the multiplication among numbers in Excel.
QUOTIENT	Returns the integer part of a division without remainder.
RAND	Returns a random number between 0 and 1.
RANDBETWEEN	Returns a random integer between two given numbers called bottom and top.
ROUND	Rounds a number based on the provided number of digits.
ROUNDDOWN	Rounds a number down toward zero.
ROUNDUP	Rounds a number up away from zero.
SEQUENCE	Creates a sequence of numeric values.
SIGN	Returns a number’s sign as 0, +1, or -1.
SIN	Determines the sine of angles in Excel.
SQRT	Returns the square root of a number.
SUBTOTAL	Offers 11 maths & trig functions to perform by inserting the corresponding argument.
SUM	Adds all the numbers in each range of cells.
SUMIF	Adds the cells specified by a given condition or criteria.
SUMIFS	Adds the cells given by specified conditions or criteria.
SUMPRODUCT	Takes one or more arrays as an argument, multiplies the corresponding values of all the arrays and then returns the sum of the products.
TAN	Determines the tangent of an angle.
TRUNC	Truncates a number to an integer by removing the decimal, or fractional, part of the number.

Excel Statistical Functions

These functions enable you to calculate various statistical measures, such as averages, standard deviations, correlations, and more.

Function Name	Objective
AVERAGE	Returns the average (arithmetic mean) of its arguments which can be numbers or names, arrays, or references that contain numbers.
AVERAGEA	Calculates the average of a group of values – numbers, texts or boolean – and returns the average (arithmetic mean) of the values.
AVERAGEIF	Finds average for the cells specified by a given condition or criteria.
AVERAGEIFS	Returns the average of the cells of an array that satisfy one or more given criteria.
CORREL	Calculates the correlation coefficient of two cell ranges.
COUNT	Counts the number of cells in a range that contains numbers.
COUNTA	Counts the number of cells in a range that is not empty.
COUNTBLANK	Counts the number of empty cells in a specified range of cells.
COUNTIF	Counts the number of cells within a range that meets the given condition.
COUNTIFS	Counts the number of cells in one or more given arrays that maintain one or more specific criteria.
FORECAST	Calculates or predicts a future value based on existing value.
FREQUENCY	Returns how often numeric values occurred within the ranges you specify in a bin table of a set of data or dataset.
GAMMA	Finds the gamma function value of a number.
GROWTH	Calculates predictive exponential growth for a given set of data.
INTERCEPT	Determines the location where a regression line will intersect the y-axis.
LARGE	Returns the K-th largest value in a dataset where K must be a positive integer.
LINEST	Finds the least-squares method to compute the statistics for a straight line and returns an array describing that line.
MAX	Returns the largest value in a given list of arguments.
MEDIAN	Returns the median of a group of numbers.
MIN	Extracts the lowest or smallest value from a range of cells or cell references.
MODE	Returns the most frequently occurring or repetitive value in an array or a range of data.
PERCENTILE	Calculates the kth percentile of the values in a particular data range.
PERMUT	Returns the number of permutations for a chosen number of objects from a total number of objects without repetitions.
QUARTILE	Finds the quartile (each of four equal groups) for a conveyed set of data.
RANK	Returns the position of a given number in a given list of other numbers.
SKEW	Calculates the skewness of a range of data in Excel.
SLOPE	Returns the slope of the linear regression line through known y’s and known x’s data points.
SMALL	Finds the k-th (generally known as nth) smallest value in a data set.
STDEV	Estimates standard deviation.
VAR	Returns the variance of a sample taken from population data.

Excel Text Functions

These functions enable you to extract specific parts of a text, combine or concatenate multiple text strings, change the case of text, convert numbers to text, and more.

Function Name	Objective
CHAR	Returns the character specified by the code number from the character set for your computer.
CLEAN	Removes all of the non-printable characters from text.
CODE	Returns a numeric code for the first character in a text string, in the character set used by your computer.
CONCATENATE	Joins two or more text values or numbers into one single text value.
DOLLAR	Converts a number into text in the form of a currency.
EXACT	Compares two texts and then returns TRUE (in case the texts are exactly the same) or FALSE (in case the texts are exactly not the same).
FIND	Returns the starting position of a case-sensitive text string within another text string.
FIXED	Rounds a number to the fixed number of decimals, and formats the number in decimal format using a period and commas.
LEFT	Returns a specified number of characters from the start of the provided text string.
LEN	Returns the length of a given string.
LOWER	Converts all the letters in a text string to lowercase.
MID	Returns a specific number of characters from the middle of a string, given a specific starting position.
PROPER	Capitalizes the first letter of each word in a given text string.
REPLACE	Replaces a part of a text string with a different text string.
REPT	Repeats text a given number of times.
RIGHT	Extracts a specified number of characters from a given string from right to left.
SEARCH	Returns the number of characters after finding a specific character or text string, reading from left to right.
SUBSTITUTE	Replaces existing text with new text in a text string.
TEXT	Converts a value to text in a specific number format.
TEXTJOIN	Concatenates a list or range of text strings into a single string using a delimiter.
TRIM	Removes the extra spaces from a text string.
UPPER	Converts a text string to all uppercase letters.
VALUE	Converts a text string that represents a number to a number.

Excel Functions: Knowledge Hub

<< Go Back to Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

2 Comments

Jitendra Sahu Mar 21, 2024 at 8:05 PM

Dear Ahmed Sir, Thank you for the excel demy website which is very helpful for excel.
- Reply
  Shamima Sultana Mar 24, 2024 at 9:37 AM
  
  Hello Jitendra Sahu,
  
  Thanks for your kind words. Our goal is to make Excel easy for everyone.
  
  Regards
  ExcelDemy