{"id":6763,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/somme-series\/"},"modified":"2021-02-26T08:13:32","modified_gmt":"2021-02-26T08:13:32","slug":"seriessum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/seriessum\/","title":{"rendered":"SOMME.SERIES"},"content":{"rendered":"

La fonction SERIESSUM<\/strong>, ou SOMME.SERIES<\/strong> en fran\u00e7ais, est disponible \u00e0 la fois dans Microsoft Excel et Google Sheets. Elle est particuli\u00e8rement utile pour calculer la somme d’une s\u00e9rie de puissances, une op\u00e9ration fr\u00e9quente en math\u00e9matiques et en finance.<\/p>\n

Description de la fonction<\/h2>\n

La fonction SOMME.SERIES<\/code> calcule la somme d’une s\u00e9rie de puissances selon la formule suivante :<\/p>\n

\u03a3 (n=0 \u00e0 N) C * x^(n*i)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • C<\/strong> repr\u00e9sente la valeur initiale du coefficient.<\/li>\n
  • x<\/strong> est la base de la puissance.<\/li>\n
  • n<\/strong> est l’incr\u00e9menteur, qui commence \u00e0 0 et se termine \u00e0 N inclus.<\/li>\n
  • N<\/strong> d\u00e9signe le nombre total de termes de la s\u00e9rie.<\/li>\n
  • i<\/strong> est l’intervalle d’incr\u00e9ment entre les exposants de chaque terme.<\/li>\n<\/ul>\n
    Syntaxe :<\/p>\n
    =SOMME.SERIES(x; n; i; valeurs)<\/code><\/pre>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Ci-dessous, des exemples illustrent l’efficacit\u00e9 de l’utilisation de la fonction SOMME.SERIES<\/strong>.<\/p>\n
    Exemple 1 : Calcul d’une s\u00e9rie g\u00e9om\u00e9trique simple<\/h2>\n
    Supposez que vous vouliez calculer la somme des termes de la s\u00e9rie g\u00e9om\u00e9trique 1 + x + x^2 + x^3 + … + x^10, avec x = 2.<\/p>\n
    Voici comment vous utiliserez SOMME.SERIES<\/code> :<\/p>\n
    =SOMME.SERIES(2; 0; 1; 10)<\/code><\/pre>\n
    Le r\u00e9sultat est 2047.<\/p>\n
    Exemple 2 : Utilisation en finance pour le calcul des int\u00e9r\u00eats compos\u00e9s<\/h2>\n
    Imaginez que vous partiez d’un capital de 1000 euros, avec un taux d’int\u00e9r\u00eat annuel de 5%, et que vous souhaitiez conna\u00eetre la valeur de cet investissement apr\u00e8s 5 ans, en tenant compte des int\u00e9r\u00eats compos\u00e9s annuellement.<\/p>\n\n\n\n
    Formule<\/th>\nDescription<\/th>\n<\/tr>\n
    \n
    =1000 * SOMME.SERIES(1.05; 0; 1; 5)<\/code><\/pre>\n<\/td>\n
    		Le capital initial multipli\u00e9 par la somme des s\u00e9ries de puissances donne la valeur future de l’investissement.<\/td>\n<\/tr>\n<\/table>\n
    Cela donne une valeur future d’environ 1276.28 euros.<\/p>\n
    En r\u00e9sum\u00e9<\/h2>\n
    La fonction SOMME.SERIES<\/strong> dans Excel et Google Sheets se r\u00e9v\u00e8le \u00eatre un outil puissant pour le calcul de s\u00e9ries exponentielles et pour la mod\u00e9lisation de sc\u00e9narios financiers n\u00e9cessitant des calculs it\u00e9ratifs d’int\u00e9r\u00eats ou de croissance. Les exemples pr\u00e9sent\u00e9s ci-dessus ne sont que quelques-unes des nombreuses applications possibles de cette fonction versatile.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la somme d\u2019une s\u00e9Rie g\u00e9om\u00e9tRique en s\u2019appuyant suR une foRmule<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6763","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SERIESSUM (SOMME.SERIES) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SERIESSUM (SOMME.SERIES) 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\/seriessum\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SERIESSUM (SOMME.SERIES) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SERIESSUM (SOMME.SERIES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/seriessum\/\" \/>\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:13:32+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SERIESSUM (SOMME.SERIES) 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\/seriessum\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/seriessum\/\",\"name\":\"Fonction SERIESSUM (SOMME.SERIES) 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:13:32+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SERIESSUM (SOMME.SERIES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/seriessum\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/seriessum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/seriessum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SOMME.SERIES\"}]},{\"@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 SERIESSUM (SOMME.SERIES) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SERIESSUM (SOMME.SERIES) 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\/seriessum\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SERIESSUM (SOMME.SERIES) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SERIESSUM (SOMME.SERIES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/seriessum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:32+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SERIESSUM (SOMME.SERIES) 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\/seriessum\/","url":"https:\/\/functiontranslator.com\/fr\/seriessum\/","name":"Fonction SERIESSUM (SOMME.SERIES) 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:13:32+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SERIESSUM (SOMME.SERIES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/seriessum\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/seriessum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/seriessum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"SOMME.SERIES"}]},{"@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\/6763","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=6763"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6763\/revisions"}],"predecessor-version":[{"id":29773,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6763\/revisions\/29773"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}