{"id":6467,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/nb-coupons\/"},"modified":"2021-02-26T08:03:50","modified_gmt":"2021-02-26T08:03:50","slug":"coupnum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/coupnum\/","title":{"rendered":"NB.COUPONS"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction COUPNUM<\/code> ou NB.COUPONS<\/code> dans Microsoft Excel et Google Sheets est con\u00e7ue pour calculer le nombre total de coupons d’int\u00e9r\u00eat qu’un investisseur recevra entre la date de d\u00e9but et la date de maturit\u00e9 d’une obligation. Cette fonction est essentielle dans le secteur financier pour planifier les flux de tr\u00e9sorerie provenant des paiements d’int\u00e9r\u00eats des obligations.<\/p>\n

Syntaxe<\/h2>\n
COUPNUM(date_emission, date_echeance, nombre_paiements_par_an, [convention_basse])<\/code><\/pre>\n
    \n
  • date_emission<\/code> : La date \u00e0 laquelle l\u2019obligation est \u00e9mise.<\/li>\n
  • date_echeance<\/code> : La date \u00e0 laquelle l\u2019obligation arrive \u00e0 \u00e9ch\u00e9ance.<\/li>\n
  • nombre_paiements_par_an<\/code> : Fr\u00e9quence des paiements d’int\u00e9r\u00eats par an (par exemple, 2 pour un paiement semi-annuel).<\/li>\n
  • convention_basse<\/code> (optionnelle) : Un code num\u00e9rique (0 ou 1) qui d\u00e9termine la m\u00e9thode de comptabilisation des jours. Si omise, la valeur par d\u00e9faut est 0 (US(NASD) 30\/360), mais peut \u00e9galement \u00eatre r\u00e9gl\u00e9e sur 1 (Actuel\/Actuel).<\/li>\n<\/ul>\n
    Exemple d’application<\/h2>\n
    Voici deux exemples d\u00e9montrant l’application pratique de la fonction COUPNUM<\/code>.<\/p>\n
    Exemple 1 : Obligation classique<\/h2>\n\n\n\n\n\n
    Param\u00e8tre<\/th>\nValeur<\/th>\n<\/tr>\n
    Date d’\u00e9mission<\/td>\n01\/01\/2020<\/td>\n<\/tr>\n
    Date d’\u00e9ch\u00e9ance<\/td>\n31\/12\/2025<\/td>\n<\/tr>\n
    Paiements par an<\/td>\n2<\/td>\n<\/tr>\n<\/table>\n
     =COUPNUM(\"01\/01\/2020\"; \"31\/12\/2025\"; 2)<\/code> <\/pre>\n
    Cet exemple montre une obligation avec des paiements semi-annuels \u00e9mise le 01\/01\/2020 et arrivant \u00e0 \u00e9ch\u00e9ance le 31\/12\/2025. La fonction retournera 12, indiquant qu’il y aura 12 paiements d’int\u00e9r\u00eat jusqu’\u00e0 l’\u00e9ch\u00e9ance de l’obligation.<\/p>\n
    Exemple 2 : Paiements annuels<\/h2>\n\n\n\n\n\n
    Param\u00e8tre<\/th>\nValeur<\/th>\n<\/tr>\n
    Date d’\u00e9mission<\/td>\n01\/03\/2022<\/td>\n<\/tr>\n
    Date d’\u00e9ch\u00e9ance<\/td>\n01\/03\/2025<\/td>\n<\/tr>\n
    Paiements par an<\/td>\n1<\/td>\n<\/tr>\n<\/table>\n
     =COUPNUM(\"01\/03\/2022\"; \"01\/03\/2025\"; 1)<\/code> <\/pre>\n
    Voici un cas d’une obligation avec des paiements annuels. Elle est \u00e9mise le 01\/03\/2022 et \u00e9choit le 01\/03\/2025. La fonction comptabilisera 3 paiements d’int\u00e9r\u00eat, correspondant aux trois ann\u00e9es jusqu’\u00e0 la maturit\u00e9 de l’obligation.<\/p>\n
    Ces exemples illustrent la mani\u00e8re dont la fonction COUPNUM<\/code> peut \u00eatre utilis\u00e9e pour d\u00e9terminer le nombre de paiements d’int\u00e9r\u00eats \u00e0 pr\u00e9voir pour diff\u00e9rentes structures d’obligations.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le nombRe de coupons dus entRe la date de R\u00e8glement et la date d\u2019\u00e9ch\u00e9ance<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[311],"tags":[],"class_list":["post-6467","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUPNUM (NB.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/coupnum\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUPNUM (NB.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/coupnum\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:03:50+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupnum\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/coupnum\/\",\"name\":\"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:03:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUPNUM (NB.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupnum\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/coupnum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/coupnum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finances\",\"item\":\"https:\/\/functiontranslator.com\/fr\/finances\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"NB.COUPONS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUPNUM (NB.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/coupnum\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUPNUM (NB.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/coupnum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/coupnum\/","url":"https:\/\/functiontranslator.com\/fr\/coupnum\/","name":"Fonction COUPNUM (NB.COUPONS) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:03:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUPNUM (NB.COUPONS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/coupnum\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/coupnum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/coupnum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Finances","item":"https:\/\/functiontranslator.com\/fr\/finances\/"},{"@type":"ListItem","position":3,"name":"NB.COUPONS"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6467"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6467\/revisions"}],"predecessor-version":[{"id":29479,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6467\/revisions\/29479"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}