{"id":6439,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/choisir\/"},"modified":"2021-02-26T08:03:13","modified_gmt":"2021-02-26T08:03:13","slug":"choose","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/choose\/","title":{"rendered":"CHOISIR"},"content":{"rendered":"

Pr\u00e9sentation de la fonction CHOISIR<\/h2>\n

La fonction CHOISIR<\/em> permet de s\u00e9lectionner une valeur ou une action parmi une liste d’options, en fonction d’un index num\u00e9rique sp\u00e9cifi\u00e9. Cette fonction est particuli\u00e8rement pratique pour extraire des donn\u00e9es cibl\u00e9es d’un ensemble pr\u00e9d\u00e9fini.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction CHOISIR :<\/p>\n

=CHOISIR(index_num, valeur1, [valeur2], ...)<\/code><\/pre>\n
    \n
  • index_num<\/strong> : C’est l’argument num\u00e9rique qui d\u00e9termine quelle valeur ou action est retourn\u00e9e. L’index doit \u00eatre un entier.<\/li>\n
  • valeur1, valeur2, …<\/strong> : Ces arguments constituent les diff\u00e9rentes options parmi lesquelles l’index va effectuer une s\u00e9lection. Vous pouvez sp\u00e9cifier plusieurs valeurs.<\/li>\n<\/ul>\n
    Exemple de base<\/h2>\n
    Imaginons que vous souhaitez identifier un mois sp\u00e9cifique \u00e0 partir d’un nombre. Voici comment utiliser la fonction :<\/p>\n
    =CHOISIR(2, \"Janvier\", \"F\u00e9vrier\", \"Mars\", \"Avril\", \"Mai\")<\/code><\/pre>\n
    Cette formule retourne \u00ab\u00a0F\u00e9vrier\u00a0\u00bb<\/em>, car il s’agit de la seconde valeur dans la liste des arguments.<\/p>\n
    Utilisations pratiques dans diff\u00e9rents contextes<\/h2>\n
    Choix de l’action selon la condition<\/h3>\n
    Supposons que vous g\u00e9rez des statuts de commandes dans une entreprise de e-commerce. Vous pourriez utiliser la fonction CHOISIR pour afficher un message adapt\u00e9 selon l’\u00e9tat de la commande :<\/p>\n\n\n\n\n\n\n
    Code \u00c9tat<\/th>\nMessage<\/th>\n<\/tr>\n
    1<\/td>\nCommande re\u00e7ue<\/td>\n<\/tr>\n
    2<\/td>\nEn pr\u00e9paration<\/td>\n<\/tr>\n
    3<\/td>\nExp\u00e9di\u00e9e<\/td>\n<\/tr>\n
    4<\/td>\nLivr\u00e9e<\/td>\n<\/tr>\n<\/table>\n
    =CHOISIR(A2, \"Commande re\u00e7ue\", \"En pr\u00e9paration\", \"Exp\u00e9di\u00e9e\", \"Livr\u00e9e\")<\/code><\/pre>\n
    Cette formule v\u00e9rifie la valeur dans la cellule A2 (qui devrait \u00eatre un nombre entre 1 et 4) et retourne le message correspondant au code \u00e9tat d\u00e9crit dans le tableau ci-dessus.<\/p>\n
    S\u00e9lection de donn\u00e9es financi\u00e8res<\/h3>\n
    Consid\u00e9rons un tableau de donn\u00e9es financi\u00e8res o\u00f9 chaque colonne repr\u00e9sente un indicateur diff\u00e9rent, tel que le revenu, les d\u00e9penses, et le b\u00e9n\u00e9fice net. Voici comment s\u00e9lectionner un indicateur sp\u00e9cifique en fonction du choix d\u2019un utilisateur :<\/p>\n
    =CHOISIR(B2, C5, C6, C7)<\/code><\/pre>\n
    Dans cet exemple, la valeur en B2 d\u00e9termine quel indicateur financier est choisi (1 pour les revenus, 2 pour les d\u00e9penses, 3 pour le b\u00e9n\u00e9fice net), avec les cellules C5, C6 et C7 fournissant les donn\u00e9es correspondantes.<\/p>\n
    La fonction CHOISIR<\/em> est donc un outil tr\u00e8s flexible et efficace pour g\u00e9rer divers sc\u00e9narios dans Excel, facilitant ainsi la cr\u00e9ation de formules complexes et am\u00e9liorant la lisibilit\u00e9 des feuilles de calcul.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Choisit une valeur dans une liste<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312],"tags":[],"class_list":["post-6439","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction CHOOSE (CHOISIR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CHOOSE (CHOISIR) 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\/choose\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CHOOSE (CHOISIR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CHOOSE (CHOISIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/choose\/\" \/>\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:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CHOOSE (CHOISIR) 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\/choose\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/choose\/\",\"name\":\"Fonction CHOOSE (CHOISIR) 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:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CHOOSE (CHOISIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/choose\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/choose\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/choose\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recherche et matrices\",\"item\":\"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CHOISIR\"}]},{\"@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 CHOOSE (CHOISIR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CHOOSE (CHOISIR) 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\/choose\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CHOOSE (CHOISIR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CHOOSE (CHOISIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/choose\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CHOOSE (CHOISIR) 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\/choose\/","url":"https:\/\/functiontranslator.com\/fr\/choose\/","name":"Fonction CHOOSE (CHOISIR) 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:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CHOOSE (CHOISIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/choose\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/choose\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/choose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Recherche et matrices","item":"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/"},{"@type":"ListItem","position":3,"name":"CHOISIR"}]},{"@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\/6439","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=6439"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6439\/revisions"}],"predecessor-version":[{"id":29451,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6439\/revisions\/29451"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}