{"id":6377,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/interet-acc\/"},"modified":"2021-02-26T08:01:33","modified_gmt":"2021-02-26T08:01:33","slug":"accrint","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/accrint\/","title":{"rendered":"INTERET.ACC"},"content":{"rendered":"

La fonction ACCRINT, nomm\u00e9e INTERET.ACC en fran\u00e7ais, est employ\u00e9e dans MS Excel et Google Sheets pour d\u00e9terminer les int\u00e9r\u00eats courus d’un investissement \u00e0 taux fixe entre deux dates, souvent de la date d’\u00e9mission \u00e0 la date de r\u00e8glement. Cette fonction est particuli\u00e8rement pr\u00e9cieuse dans les milieux financiers, notamment pour les calculs li\u00e9s aux obligations et autres instruments de revenu fixe.<\/p>\n

Explication de la syntaxe<\/h2>\n

La syntaxe de la fonction INTERET.ACC dans Excel et Google Sheets est la suivante :<\/p>\n

INTERET.ACC(\u00e9mission; premier_coupon; r\u00e8glement; taux; nominal; fr\u00e9quence; base)<\/code><\/pre>\n
    \n
  • \u00e9mission<\/strong> : Date \u00e0 laquelle l’obligation est \u00e9mise.<\/li>\n
  • premier_coupon<\/strong> : Date du premier coupon vers\u00e9.<\/li>\n
  • r\u00e8glement<\/strong> : Date de r\u00e8glement ou date jusqu’\u00e0 laquelle les int\u00e9r\u00eats sont calcul\u00e9s.<\/li>\n
  • taux<\/strong> : Taux d’int\u00e9r\u00eat annuel de l’obligation.<\/li>\n
  • nominal<\/strong> : Montant principal ou nominal de l’obligation.<\/li>\n
  • fr\u00e9quence<\/strong> : Fr\u00e9quence des paiements de coupon par ann\u00e9e (1 pour annuel, 2 pour semi-annuel, 4 pour trimestriel).<\/li>\n
  • base<\/strong> : M\u00e9thode de comptage des jours utilis\u00e9e (0 = 30\/360 US; 1 = R\u00e9el\/R\u00e9el; 2 = R\u00e9el\/360; 3 = R\u00e9el\/365; 4 = 30\/360 europ\u00e9en).<\/li>\n<\/ul>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Examinons des applications concr\u00e8tes de cette fonction.<\/p>\n
    Calcul des int\u00e9r\u00eats courus pour une obligation<\/h2>\n
    Prenons le cas d’une obligation \u00e9mise le 1er janvier 2020, avec un premier coupon payable le 1er juillet 2020, et nous souhaitons calculer les int\u00e9r\u00eats courus jusqu’\u00e0 la date de r\u00e8glement du 1er avril 2020. L’obligation porte un int\u00e9r\u00eat annuel de 5% et un nominal de 1000 \u20ac, avec des paiements semi-annuels de coupons.<\/p>\n
      =INTERET.ACC(\"01\/01\/2020\"; \"01\/07\/2020\"; \"01\/04\/2020\"; 5%; 1000; 2; 0) <\/code> <\/pre>\n
    Cette formule retournera la valeur des int\u00e9r\u00eats courus pour la p\u00e9riode indiqu\u00e9e.<\/p>\n
    Impact de la base de jours sur le calcul des int\u00e9r\u00eats<\/h2>\n
    Reprenons l’exemple pr\u00e9c\u00e9dent, mais utilisons cette fois la m\u00e9thode R\u00e9el\/R\u00e9el pour le comptage des jours. Ce choix signifie que le calcul des int\u00e9r\u00eats tiendra compte du nombre r\u00e9el de jours par mois et par ann\u00e9e.<\/p>\n
      =INTERET.ACC(\"01\/01\/2020\"; \"01\/07\/2020\"; \"01\/04\/2020\"; 5%; 1000; 2; 1) <\/code> <\/pre>\n
    Ce second calcul peut produire des r\u00e9sultats l\u00e9g\u00e8rement diff\u00e9rents, illustrant les variations dues \u00e0 un d\u00e9compte exact des jours, notamment pertinent lors d’ann\u00e9es bissextiles.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie l\u2019int\u00e9R\u00eat couRu non \u00e9chu d\u2019un titRe dont l\u2019int\u00e9R\u00eat est peR\u00e7u p\u00e9Riodiquement<\/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-6377","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction ACCRINT (INTERET.ACC) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ACCRINT (INTERET.ACC) 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\/accrint\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ACCRINT (INTERET.ACC) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ACCRINT (INTERET.ACC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/accrint\/\" \/>\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:01:33+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ACCRINT (INTERET.ACC) 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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/accrint\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/accrint\/\",\"name\":\"Fonction ACCRINT (INTERET.ACC) 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:01:33+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ACCRINT (INTERET.ACC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/accrint\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/accrint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/accrint\/#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\":\"INTERET.ACC\"}]},{\"@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 ACCRINT (INTERET.ACC) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ACCRINT (INTERET.ACC) 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\/accrint\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ACCRINT (INTERET.ACC) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ACCRINT (INTERET.ACC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/accrint\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:01:33+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ACCRINT (INTERET.ACC) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/accrint\/","url":"https:\/\/functiontranslator.com\/fr\/accrint\/","name":"Fonction ACCRINT (INTERET.ACC) 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:01:33+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ACCRINT (INTERET.ACC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/accrint\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/accrint\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/accrint\/#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":"INTERET.ACC"}]},{"@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\/6377","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=6377"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6377\/revisions"}],"predecessor-version":[{"id":29390,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6377\/revisions\/29390"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}