List of all functions (by category)

Some of the content in this topic may not be applicable to some languages.

The following sections list all the Excel functions by category.

ShowDatabase functions

  • DAVERAGE function Returns the average of selected database entries
  • DCOUNT function Counts the cells that contain numbers in a database
  • DCOUNTA function Counts nonblank cells in a database
  • DGET function Extracts from a database a single record that matches specified criteria
  • DMAX function Returns the maximum value from selected database entries
  • DMIN function Returns the minimum value from selected database entries
  • DPRODUCT function Multiplies the values in a particular field of records that match the criteria in a database
  • DSTDEV function Estimates the standard deviation based on a sample of selected database entries
  • DSTDEVP function Calculates the standard deviation based on the entire population of selected database entries
  • DSUM function Adds the numbers in the field column of records in the database that match the criteria
  • DVAR function Estimates variance based on a sample from selected database entries
  • DVARP function Calculates variance based on the entire population of selected database entries
  • GETPIVOTDATA function Returns data stored in a PivotTable report

ShowDate and time functions

  • DATE function Returns the sequential serial number that represents a particular date.
  • DATEDIF function Calculates the number of days, months, or years from one date to another date.
  • DATEVALUE function Converts a date in a cell that uses the Text cell format into a sequential serial number that you can use in date calculations.
  • DAY function Returns only the day of the month of a date. The day is given as an integer, ranging from 1 to 31.
  • DAYS360 function Calculates the number of days from one date to another date based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
  • EDATE function Returns the serial number that represents the date that is a specified number of months before or after start_date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
  • EOMONTH function Returns the serial number for the last day of the month that is a specified number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
  • HOUR function Returns only the hour of a time value. The hour is given as an integer, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
  • MINUTE function Returns only the minute of a time value. The minute is given as an integer, ranging from 0 to 59.
  • MONTH function Returns only the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
  • NETWORKDAYS function Returns the number of whole working days from start_date to end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.
  • NETWORKDAYS.INTL function Returns the number of whole workdays between two dates.
  • NOW function Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result changes the cell formatting to Time.
  • SECOND function Returns only the second of a time value. The second is given as an integer, ranging from 0 (zero) to 59.
  • TIME function Returns the decimal number for a particular time. If the cell format was General before the function was entered, the result changes the cell formatting to Time.
  • TIMEVALUE function Returns the decimal number of a particular time represented by a text string. The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.).
  • TODAY function Returns the serial number of the current date. If the cell format was General before the function was entered, the result changes the cell formatting to Date.
  • WEEKDAY function Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.
  • WEEKNUM function Returns a number that indicates where the week falls within a year. The week is given as an integer.
  • WORKDAY function Returns a number that represents a date that is a specified number of working days before or after start_date. Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days worked.
  • WORKDAY.INTL function Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.
  • YEAR function Returns the year corresponding to a date. The year is returned as an integer, ranging from 1900-9999.
  • YEARFRAC function Calculates the fraction of the year represented by the number of whole days from start_date to end_date. Use YEARFRAC to identify the proportion of a whole year's benefits or obligations to assign to a specific term.

ShowEngineering functions

ShowFinancial functions

  • ACCRINT function Returns the accrued interest for a security that pays periodic interest
  • ACCRINTM function Returns the accrued interest for a security that pays interest at maturity
  • AMORDEGRC function Returns the depreciation for each accounting period by using a depreciation coefficient
  • AMORLINC function Returns the depreciation for each accounting period
  • COUPDAYBS function Returns the number of days from the beginning of the coupon period to the settlement date
  • COUPDAYS function Returns the number of days in the coupon period that contains the settlement date
  • COUPDAYSNC function Returns the number of days from the settlement date to the next coupon date
  • COUPNCD function Returns the next coupon date after the settlement date
  • COUPNUM function Returns the number of coupons payable between the settlement date and maturity date
  • COUPPCD function Returns the previous coupon date before the settlement date
  • CUMIPMT function Returns the cumulative interest paid between two periods
  • CUMPRINC function Returns the cumulative principal paid on a loan between two periods
  • DB function Returns the depreciation of an asset for a specified period by using the fixed-declining balance method
  • DDB function Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
  • DISC function Returns the discount rate for a security
  • DOLLARDE function Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
  • DOLLARFR function Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
  • DURATION function Returns the annual duration of a security with periodic interest payments
  • EFFECT function Returns the effective annual interest rate
  • FV function Returns the future value of an investment
  • FVSCHEDULE function Returns the future value of an initial principal after applying a series of compound interest rates
  • INTRATE function Returns the interest rate for a fully invested security
  • IPMT function Returns the interest payment for an investment for a given period
  • IRR function Returns the internal rate of return for a series of cash flows
  • ISPMT function Calculates the interest paid during a specific period of an investment
  • MDURATION function Returns the Macaulay modified duration for a security with an assumed par value of $100
  • MIRR function Returns the internal rate of return where positive and negative cash flows are financed at different rates
  • NOMINAL function Returns the annual nominal interest rate
  • NPER function Returns the number of periods for an investment
  • NPV function Returns the net present value of an investment based on a series of periodic cash flows and a discount rate
  • ODDFPRICE function Returns the price per $100 face value of a security with an odd first period
  • ODDFYIELD function Returns the yield of a security with an odd first period
  • ODDLPRICE function Returns the price per $100 face value of a security with an odd last period
  • ODDLYIELD function Returns the yield of a security with an odd last period
  • PMT function Returns the periodic payment for an annuity
  • PPMT function Returns the payment on the principal for an investment for a given period
  • PRICE function Returns the price per $100 face value of a security that pays periodic interest
  • PRICEDISC function Returns the price per $100 face value of a discounted security
  • PRICEMAT function Returns the price per $100 face value of a security that pays interest at maturity
  • PV function Returns the present value of an investment
  • RATE function Returns the interest rate per period of an annuity
  • RECEIVED function Returns the amount received at maturity for a fully invested security
  • SLN function Returns the straight-line depreciation of an asset for one period
  • SYD function Returns the sum-of-years' digits depreciation of an asset for a specified period
  • TBILLEQ function Returns the bond-equivalent yield for a Treasury bill
  • TBILLPRICE function Returns the price per $100 face value for a Treasury bill
  • TBILLYIELD function Returns the yield for a Treasury bill
  • VDB function Returns the depreciation of an asset for a specified or partial period by using a declining balance method
  • XIRR function Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic
  • XNPV function Returns the net present value for a schedule of cash flows that is not necessarily periodic
  • YIELD function Returns the yield on a security that pays periodic interest
  • YIELDDISC function Returns the annual yield for a discounted security; for example, a Treasury bill
  • YIELDMAT function Returns the annual yield of a security that pays interest at maturity

ShowInformation functions

ShowLogical functions

ShowLookup and reference functions

ShowMath and trigonometry functions

ShowStatistical functions

ShowText functions

  • ASC function Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
  • CHAR function Returns the character specified by the code number
  • CLEAN function Removes all nonprintable characters from text
  • CODE function Returns a numeric code for the first character in a text string
  • CONCATENATE function Joins several text items into one text item
  • DOLLAR function Converts a number to text, using the $ (dollar) currency format
  • EXACT function Checks to see if two text values are identical
  • FIND function Finds one text value within another (case-sensitive)
  • FINDB function Finds one text value within another (case-sensitive) and returns the number of the starting position, based on the number of bytes that each character uses
  • FIXED function Formats a number as text with a fixed number of decimals
  • JIS function Changes half-width (single-byte) characters within a string to full-width (double-byte) characters
  • LEFT function Returns the leftmost characters from a text value
  • LEFTB function Returns the leftmost characters from a text value, based on the number of bytes that you specify
  • LEN function Returns the number of characters in a text string
  • LENB function Returns the number of bytes used to represent the characters in a text string
  • LOWER function Converts text to lowercase
  • MID function Returns a specific number of characters from a text string starting at the position that you specify
  • MIDB function Returns a specific number of characters from a text string starting at the position that you specify, based on the number of bytes that you specify
  • PHONETIC function Returns the phonetic characters from a text string
  • PROPER function Capitalizes the first letter in each word of a text value
  • REPLACE function Replaces characters within text
  • REPLACEB function Replaces part of a text string, based on the number of bytes that you specify, with a different text string
  • REPT function Repeats text a given number of times
  • RIGHT function Returns the rightmost characters from a text value
  • RIGHTB function Returns the last (rightmost) characters in a text string, based on the number of bytes that you specify
  • SEARCH function Finds one text value within another (not case-sensitive)
  • SEARCHB function Finds one text value within another (not case-sensitive) and returns the number of the starting position, based on the number of bytes that each character uses
  • SUBSTITUTE function Substitutes new text for old text in a text string
  • T function Converts its arguments to text
  • TEXT function Formats a number and converts it to text
  • TRIM function Removes spaces from text
  • UPPER function Converts text to uppercase
  • VALUE function Converts a text argument to a number
  • YEN function Converts a number to text, using the ¥ (yen) currency format

See also

Enter a formula

My function doesn’t work

 
 
Applies to:
Excel for Mac 2011