Excel functions (by category)
Database functions
Function
Description
DAVERAGE
Returns the average of selected database entries
DCOUNT
Counts the cells that contain numbers in a database
DCOUNTA
Counts nonblank cells in a database
DGET
Extracts from a database a single record that matches the specified criteria
DMAX
Returns the maximum value from selected database entries
DMIN
Returns the minimum value from selected database entries
DPRODUCT
Multiplies the values in a particular field of records that match the criteria in a database
DSTDEV
Estimates the standard deviation based on a sample of selected database entries
DSTDEVP
Calculates the standard deviation based on the entire population of selected database entries
DSUM
Adds the numbers in the field column of records in the database that match the criteria
DVAR
Estimates variance based on a sample from selected database entries
DVARP
Calculates variance based on the entire population of selected database entries
Date and time functions
Function
Description
DATE
Returns the serial number of a particular date
DATEVALUE
Converts a date in the form of text to a serial number
DAY
Converts a serial number to a day of the month
DAYS360
Calculates the number of days between two dates based on a 360-day year
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 before or after a specified number
of months
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
NOW
Returns the serial number of the current date and time
SECOND
Converts a serial number to a second
TIME
Returns the serial number of a particular time
TIMEVALUE
Converts a time in the form of text to a serial number
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 with a
year
WORKDAY
Returns the serial number of the date before or after a specified number of workdays
YEAR
Converts a serial number to a year
YEARFRAC
Returns the year fraction representing the number of whole days between start_date and
end_date
Engineering functions
Function
Description
BESSELI
Returns the modified Bessel function In(x)
BESSELJ
Returns the Bessel function Jn(x)
BESSELK
Returns the modified Bessel function Kn(x)
BESSELY
Returns the Bessel function Yn(x)
BIN2DEC
Converts a binary number to decimal
BIN2HEX
Converts a binary number to hexadecimal
BIN2OCT
Converts a binary number to octal
COMPLEX
Converts real and imaginary coefficients into a complex number
CONVERT
Converts a number from one measurement system to another
DEC2BIN
Converts a decimal number to binary
DEC2HEX
Converts a decimal number to hexadecimal
DEC2OCT
Converts a decimal number to octal
DELTA
Tests whether two values are equal
ERF
Returns the error function
ERFC
Returns the complementary error function
GESTEP
Tests whether a number is greater than a threshold value
HEX2BIN
Converts a hexadecimal number to binary
HEX2DEC
Converts a hexadecimal number to decimal
HEX2OCT
Converts a hexadecimal number to octal
IMABS
Returns the absolute value (modulus) of a complex number
IMAGINARY
Returns the imaginary coefficient of a complex number
IMARGUMENT
Returns the argument theta, an angle expressed in radians
IMCONJUGATE
Returns the complex conjugate of a complex number
IMCOS
Returns the cosine of a complex number
IMDIV
Returns the quotient of two complex numbers
IMEXP
Returns the exponential of a complex number
IMLN
Returns the natural logarithm of a complex number
IMLOG10
Returns the base-10 logarithm of a complex number
IMLOG2
Returns the base-2 logarithm of a complex number
IMPOWER
Returns a complex number raised to an integer power
IMPRODUCT
Returns the product of from 2 to 29 complex numbers
IMREAL
Returns the real coefficient of a complex number
IMSIN
Returns the sine of a complex number
IMSQRT
Returns the square root of a complex number
IMSUB
Returns the difference between two complex numbers
IMSUM
Returns the sum of complex numbers
OCT2BIN
Converts an octal number to binary
OCT2DEC
Converts an octal number to decimal
OCT2HEX
Converts an octal number to hexadecimal
Financial functions
Function
Description
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
AMORDEGRC
Returns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC
Returns the depreciation for each accounting period
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 some other method that you specify
DISC
Returns the discount rate for a security
DOLLARDE
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal
number
DOLLARFR
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a
fraction
DURATION
Returns the annual duration of a security with periodic interest payments
EFFECT
Returns the effective annual interest rate
Returns the future value of an investment
rates
INTRATE
Returns the interest rate for a fully invested security
IPMT
Returns the interest payment for an investment for a given period
IRR
Returns the internal rate of return for a series of cash flows
ISPMT
Calculates the interest paid during a specific period of an investment
MDURATION
Returns the Macauley modified duration for a security with an assumed par value of $100
different rates
NOMINAL
Returns the annual nominal interest rate
NPER
Returns the number of periods for an investment
