ERROR.TYPE function
description: Returns the number of an error. syntax: =ERROR.TYPE( error_val ) required arguments: error_value A range of cells.
Category: functions
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 date. settlement Security’s…
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…
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…
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…
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…
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:…
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…
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…
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…
