{"id":6716,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/permutationa\/"},"modified":"2021-02-26T08:11:47","modified_gmt":"2021-02-26T08:11:47","slug":"permutationa","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/permutationa\/","title":{"rendered":"PERMUTATIONA"},"content":{"rendered":"

La fonction PERMUTATIONA<\/strong> dans MS Excel et Google Sheets est con\u00e7ue pour d\u00e9terminer le nombre total de permutations possibles d’un ensemble d’objets o\u00f9 des doublons ou r\u00e9p\u00e9titions sont autoris\u00e9s. Elle est fr\u00e9quemment utilis\u00e9e dans des domaines tels que les statistiques et la probabilit\u00e9, ainsi que dans toutes situations n\u00e9cessitant l’arrangement ou la classification des ensembles.<\/p>\n

Description et Syntaxe<\/h2>\n

La syntaxe de la fonction PERMUTATIONA<\/strong> est :<\/p>\n

=PERMUTATIONA(nombre; nombre_choisi)<\/code><\/pre>\n
    \n
  • nombre<\/strong> : Correspond au nombre total d’\u00e9l\u00e9ments disponibles pour la permutation. Ce param\u00e8tre doit \u00eatre un entier positif.<\/li>\n
  • nombre_choisi<\/strong> : Repr\u00e9sente le nombre d’\u00e9l\u00e9ments \u00e0 inclure dans chaque permutation. Ce nombre doit \u00e9galement \u00eatre un entier positif.<\/li>\n<\/ul>\n
    Cette fonction calcule le nombre de mani\u00e8res diff\u00e9rentes d’arranger nombre_choisi<\/strong> \u00e9l\u00e9ments parmi un ensemble de nombre<\/strong> \u00e9l\u00e9ments, chaque \u00e9l\u00e9ment pouvant appara\u00eetre plus d’une fois dans chaque arrangement.<\/p>\n
    Exemples<\/h2>\n
    Voici quelques exemples d\u00e9montrant l’utilisation de la fonction PERMUTATIONA.<\/p>\n
    =PERMUTATIONA(3, 2) \/\/ Calcule le nombre de permutations de 2 \u00e9l\u00e9ments parmi 3 avec r\u00e9p\u00e9tition<\/code><\/pre>\n
    Cette formule renvoie 9 puisqu’il existe 9 permutations possibles : 11, 12, 13, 21, 22, 23, 31, 32, 33.<\/p>\n
    Sc\u00e9narios Pratiques<\/h2>\n
    Examinons des situations concr\u00e8tes o\u00f9 cette fonction peut \u00eatre utile.<\/p>\n
    Gestion de projet<\/h2>\n
    Imaginons une \u00e9quipe de 5 personnes. Vous souhaitez savoir combien de fa\u00e7ons diff\u00e9rentes vous pouvez assigner 2 t\u00e2ches \u00e0 n’importe quel membre de l’\u00e9quipe, m\u00eame en r\u00e9p\u00e9tant des membres.<\/p>\n
    Solution :<\/strong><\/p>\n
    =PERMUTATIONA(5, 2)<\/code><\/pre>\n
    Cette formule retourne 25, indiquant qu’il existe 25 mani\u00e8res diff\u00e9rentes de r\u00e9partir 2 t\u00e2ches parmi 5 membres avec r\u00e9p\u00e9tition.<\/p>\n
    Marketing et promotions<\/h2>\n
    Consid\u00e9rez un supermarch\u00e9 qui propose une promotion sur 10 produits diff\u00e9rents, permettant \u00e0 chaque client de choisir 4 produits, avec la possibilit\u00e9 de s\u00e9lectionner plusieurs fois le m\u00eame produit.<\/p>\n
    Solution :<\/strong><\/p>\n
    =PERMUTATIONA(10, 4)<\/code><\/pre>\n
    Le r\u00e9sultat indique qu’il existe 10 000 combinaisons possibles pour qu’un client choisisse ses 4 produits parmi 10, avec r\u00e9p\u00e9tition.<\/p>\n
    Comme illustr\u00e9, la fonction PERMUTATIONA<\/strong> s\u2019av\u00e8re cruciale pour \u00e9valuer des sc\u00e9narios offrant de multiples configurations possibles o\u00f9 la r\u00e9p\u00e9tition est permise, facilitant ainsi la planification et l’analyse dans divers contextes professionnels ou de recherche.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le nombre de permutations pour un nombre d\u2019objets donn\u00e9 (avec r\u00e9p\u00e9titions) pouvant \u00eatre s\u00e9lectionn\u00e9s \u00e0 partir du nombre total d\u2019objets<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[315],"tags":[],"class_list":["post-6716","post","type-post","status-publish","format-standard","hentry","category-statistiques"],"acf":[],"yoast_head":"\nFonction PERMUTATIONA dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PERMUTATIONA 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\/permutationa\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PERMUTATIONA dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PERMUTATIONA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/permutationa\/\" \/>\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:11:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PERMUTATIONA 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\/permutationa\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/permutationa\/\",\"name\":\"Fonction PERMUTATIONA 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:11:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PERMUTATIONA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/permutationa\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/permutationa\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/permutationa\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistiques\",\"item\":\"https:\/\/functiontranslator.com\/fr\/statistiques\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PERMUTATIONA\"}]},{\"@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 PERMUTATIONA dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PERMUTATIONA 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\/permutationa\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PERMUTATIONA dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PERMUTATIONA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/permutationa\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PERMUTATIONA 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\/permutationa\/","url":"https:\/\/functiontranslator.com\/fr\/permutationa\/","name":"Fonction PERMUTATIONA 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:11:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PERMUTATIONA d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/permutationa\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/permutationa\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/permutationa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Statistiques","item":"https:\/\/functiontranslator.com\/fr\/statistiques\/"},{"@type":"ListItem","position":3,"name":"PERMUTATIONA"}]},{"@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\/6716","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=6716"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6716\/revisions"}],"predecessor-version":[{"id":29727,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6716\/revisions\/29727"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6716"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6716"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}