Microsoft Office Tutorials and References
In Depth Information
IMSQRT
Returns the square root of a complex number.
IMSUB
Returns the difference of two complex numbers.
IMSUM
Returns the sum of complex numbers.
IMTAN**
Returns the tangent of a complex number.
OCT2BIN
Converts an octal number to binary.
OCT2DEC
Converts an octal number to decimal.
OCT2HEX
Converts an octal number to hexadecimal.
* Indicates a function introduced in Excel 2010.** Indicates a function introduced in Excel 2013.
Table A-6: Financial Category Functions
Function
What It Does
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.
Returns the depreciation for each accounting period. (The depreciation
coefficient depends on the life of the assets.)
AMORLINC
Returns the number of days from the beginning of the coupon period to the
settlement date.
COUPDAYBS
Returns the number of days in the coupon period that contains the settle-
ment date.
COUPDAYS
Returns the number of days from the settlement date to the next coupon
date.
COUPDAYSNC
COUPNCD
Returns the next coupon date after the settlement date.
Returns the number of coupons payable between the settlement date and
maturity date.
COUPNUM
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.
Search JabSto ::




Custom Search