ERROR.TYPE function

description: Returns the number of an error.   syntax: =ERROR.TYPE( error_val )   required arguments: error_value A range of cells.

Posted On

ACCRINTM function

description: Returns the accrued interest for a security that pays interest at maturity.   syntax: ACCRINTM( issue, settlement, rate, par,  [basis] )   required arguments:   issue Security’s issue…

Posted On

AMORDEGRC function

description: Returns the depreciation for each accounting period (French accounting system only), including any partial period.   syntax: AMORDEGRC( cost, date_purchased, first_period, salvage, period, rate, [basis] )   required arguments: cost…

Posted On

AMORLINC function

description: Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in…

Posted On

COUPNCD function

description: Calculates the next coupon date after the settlement date.   syntax: COUPNUM( settlement, maturity, frequency, [basis] )   required arguments: settlement The security settlement date is the…

Posted On

COUPDAYS function

description: Calculates the number of days in the coupon period that contains the settlement date.   syntax: COUPNUM( settlement, maturity, frequency, [basis] )   required arguments: settlement The…

Posted On

COUPDAYBS function

description: Calculates the number of days from the beginning of the coupon period to the settlement date.   syntax: COUPNUM( settlement, maturity, frequency, [basis] )   required arguments:…

Posted On

COUPDAYSNC function

description: Calculates the number of days from the settlement date to the next coupon date.   syntax: COUPDAYSNC( settlement, maturity, frequency, [basis] )   required arguments: settlement The…

Posted On

COUPNUM function

description: Calculates the number of coupons payable between the settlement date and the maturity date, and rounds the result to the nearest whole…

Posted On

ACCRINT function

description: Let’s suppose you are the original buyer of a bond and you buy that bond after the issue date, the bond will…

Posted On