Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: COUPNUM function

COUPNUM function: Description, Usage, Syntax, Examples and Explanation

What is COUPNUM function in Excel? COUPNUM function is one of the Financial functions in Microsoft Excel that returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. Syntax of┬áCOUPNUM function COUPNUM(settlement, maturity, frequency, [basis]) The COUPNUM function syntax has the following arguments: Settlement: The security’s settlement date. The security…