Microsoft Office Tutorials and References
In Depth Information
Returns the square root of a complex number.
Returns the difference of two complex numbers.
Returns the sum of complex numbers.
Returns the tangent of a complex number.
Converts an octal number to binary.
Converts an octal number to decimal.
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
What It Does
Returns the accrued interest for a security that pays periodic interest.
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.)
Returns the number of days from the beginning of the coupon period to the
Returns the number of days in the coupon period that contains the settle-
Returns the number of days from the settlement date to the next coupon
Returns the next coupon date after the settlement date.
Returns the number of coupons payable between the settlement date and
Returns the previous coupon date before the settlement date.
Returns the cumulative interest paid between two periods.
Returns the cumulative principal paid on a loan between two periods.