Here is a list of over 100 Excel functions and formulas to help you create better spreadsheets. These functions have been categorised to for ease of use. The most common types of functions that most Excel users will implement are mathematical, logical and lookups, but there are some very powerful functions that you may not have come across before. This list will help to give you ideas of how to combine many different functions to create more effective spreadsheets.

The categories are DATE and TIME functions, FINANCIAL functions, LOGICAL functions, LOOKUP and REFERENCE functions, MATHEMATICAL functions, STATISTICAL functions and TEXT functions.

Excel DATE and TIME Functions

Function	Description
DATE	Returns the serial number of a particular date
DATEDIF	Calculates the number of days, months or years between two dates
DATEVALUE	Converts a data in the form of text to a serial number
DAY	Converts a serial number to a day of the month
DAYS	Returns the number of days between two dates
EDATE	Returns the serial number of the date that is the indicated number of months before or after the start date
EOMONTH	Returns the serial number of the last day of the month
HOUR	Converts a serial number to an hour
MINUTE	Converts a serial number to a minute
MONTH	Converts a serial number to a month
NETWORKDAYS	Returns the number of whole workdays between two dates
NETWORKDAYS.INTL	Returns the number of who workdays between two dates using parameters to indicate which and how many days are weekend days
NOW	Returns the serial number of the current date and time
SECOND	Converts a serial number to a second
TODAY	Returns the serial number of today’s date
WEEKDAY	Converts a serial number to a day of the week
WEEKNUM	Converts a serial number to a number representing where the week falls numerically within a year
WORKDAY	Returns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL	Returns the serial number of the date before or after a specific number of workdays using parameters to indicate which and how many days are weekend days

Excel FINANCIAL Functions

ACCRINT	Returns the accrued interest for a security that pays periodic interest
ACCRINTM	Returns the accrued interest for a security that pays interest at maturity
COUPDAYBS	Returns the number of days from the beginning of the coupon period to the settlement date
COUPDAYS	Returns the number of days in the coupon period that contains the settlement date
COUPDAYSNC	Returns the number of days from the settlement date to the next coupon date
COUPNCD	Returns the next coupon date after the settlement date
COUPNUM	Returns the number of coupons payable between the settlement date and maturity date
COUPPCD	Returns the previous coupon date before the settlement date
CUMIPMT	Returns the cumulative interest paid between two periods
CUMPRINC	Returns the cumulative principal paid on a loan between two periods
DB	Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
DDB	Returns the depreciation of an asset for a specified period by using the double-declining balance method or other method that you specify
DISC	Returns the discount rate for a security
EFFECT	Returns the effective annual interest rate
FV	Returns the future value of an investment
FVSCHEDULE	Returns the future value of an initial principal after applying a series of compound interest rates
IRR	Returns the internal rate of return for a series of cash flows
NOMINAL	Returns the annual nominal interest rate
NPV	Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
PMT	Returns the periodic payment for an annuity
PPMT	Returns the payment on the principal for an investment for a given period
PV	Returns the present value of an investment
RATE	Returns the interest rate per period of annuity
RRI	Returns the interest rate per period of an annuity
YIELD	Returns the yield of a security that pays periodic interest

Excel LOGICAL Functions

AND	Returns TRUE if all of its arguments are TRUE
FALSE	Returns the logical value FALSE
IF	Specifies a logical test to perform
IFERROR	Returns a value that is specified if a formula evaluates to an error; otherwise returns the result of the formula
IFNA	Returns the value that is specified if the expression resolves to #N/A, otherwise returns the result of the expression
IFS	Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition
NOT	Reverses the logic of its argument
OR	Returns TRUE if any argument is TRUE
TRUE	Returns the logical value TRUE

Excel LOOKUP and REFERENCE Functions

ADDRESS	Returns a reference as text to a single cell in a worksheet
AREAS	Returns the number of areas in a reference
CHOOSE	Choose a value from a list of values
COLUMN	Returns a column number from a reference
FORMULATEXT	Returns the formula at the given reference as text
GETPIVOTDATA	Returns data stored in a PivotTable report
HLOOKUP	Searches for a value in the top row of a table and returns the value from the same column in the row specified
INDEX	Uses an index to choose a value from a reference or array
INDIRECT	Returns a reference indicated by a text value
MATCH	Looks up values in a reference or array
OFFSET	Returns a reference offset from a given reference
ROW	Returns the row number of a reference
SORT	Sorts the contents of a range or array
SORTBY	Sorts the contents of a range or array based on the values of a corresponding range or array
TRANSPOSE	Returns the transpose of an array
UNIQUE	Returns a list of unique values in a list or arrange
VLOOKUP	Searches for a value in the first column of a table and returns the value from the same row in the column specified

Excel MATHEMATICAL Functions

ABS	Returns the absolute value of a number
AGGREGATE	Returns the aggregate in a list or database
INT	Rounds a number down to the nearest integer
MOD	Returns the remainder from a division
POWER	Returns the result of a number raised to a power
QUOTIENT	Returns the integer number of a division
RAND	Returns a random number between 0 and 1
RANDBETWEEN	Returns a random number between the numbers you specify
ROUND	Rounds a number to a specific number of digits
SUBTOTAL	Returns a subtotal in a list or database
SUM	Adds its arguments
SUMIF	Adds the cells specified by a given criteria
SUMIFS	Adds the cells specified by multiple criteria
SUMPRODUCT	Returns the sum of the products of corresponding array components

Excel STATISTICAL Functions

AVERAGE	Returns the average of its arguments
AVERAGEA	Returns the average of its arguments, including numbers, text and logical values
AVERAGEIF	Returns the average (arithmetic mean) of all cells in a range that meet a given criteria
AVERAGEIFS	Returns the average (arithmetic mean) of all cells in a range that meet multiple criteria
COUNT	Counts how many numbers are in a list of arguments
COUNTA	Counts how many values are in the list of arguments
COUNTBLANK	Counts the number of blank cells within a range
COUNTIF	Counts the number of cells within a range that meet the given criteria
COUNTIFS	Counts the number of cells within a range that meet multiple criteria
LARGE	Returns the k-th largest value in a data set
MAX	Returns the maximum value in a list of arguments
MAXIFS	Returns the maximum value among cells specified by a given set of conditions or criteria
MEDIAN	Returns the median of the given numbers
MIN	Returns the minimum value in a list of arguments
MINIFS	Returns the minimum value among cells specified by a given set of conditions or criteria
MODE.MULT	Returns a vertical array of the most frequently occurring or repetitive values in an array or range of data
MODE.SNGL	Returns the most common value in a data set
RANK.EQ	Returns the rank of a number in a list of numbers
SMALL	Returns the k-th smallest value in the data set

Excel TEXT Functions

CLEAN	Removes all non-printable characters from text
CONCATENATE	Combines several text items into one text item
FIND	Finds one text value within another (case-sensitive)
EXACT	Checks to see if two text values are identical
LEFT	Returns the leftmost characters from a text value
LEN	Returns the number of characters in a text string
LOWER	Converts text to lower case
NUMBERVALUE	Converts text to a number in a locale-independent manner
PROPER	Capitalises the first letter in each word of a text value
REPLACE	Replaces characters within text
REPT	Repeats text a given number of times
SEARCH	Finds one text value within another (not case-sensitive)
SUBSTITUTE	Substitute new text for old text in a text string
TEXT	Formats a number and converts it to text
TEXTJOIN	Combines the text from multiple ranges and/or strings and includes an optional delimiter between each text value that will be combined
TRIM	Removes spaces from text
UPPER	Converts text to uppercase
VALUE	Converts a text argument to a number