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.