COUPNUM Excel Formula

By learning the basics of Microsoft Excel, users can easily obtain the techniques on how to use it. Thus, the user may also have the chance to know and be familiar with other various formulas and functions of Microsoft Excel. One of these functions that the user should be familiar of is the COUPNUM. COUPNUM functions in Microsoft Excel returns the coupon numbers which is payable between the maturity date and settlement date. This is rounded to its nearest coupon. The syntax for COUPNUM function is “COUPNUM(settlement, maturity, frequency, basis)”. It returns the error #NAME!” value if COUPNUM function is merely not available. With this, the user can load and install the “Analysis ToolPak add-in”.


Dates are entered through the DATE function cell in Excel and result to other functions or formulas. If dates are entered as text, problem may occur. Before the user utilizes the syntax for this Excel function, he must know the definition and significance of each.

  • Settlement – is considered the settlement date of security. The security settlement date is merely the date after the issued date when each security is being traded to buyer.
  • Maturity – it is the date wherein security date expires. This is considered the maturity date of security.
  • Frequency – this is the number of coupon payments in each year. Annual payments is written as frequency = 1, quarterly, frequency = 4 and semiannual, frequency = 2.
  • Basis – this is considered the type of day basis count to use.

Excel in Microsoft stores dated such chronological serial numbers which can be used in calculations. The settlement date is definitely the date wherein the buyer purchases coupons like bond. The entire argument is shortened to its integers. If maturity or settlement is not the valid date, the Excel COUPNUM function returns the error #VALUE! value. This function will return the error #NUM! value if the frequency contains any number other than 1-2 or 4.

Post comment