{"id":6796,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/si-multiple\/"},"modified":"2021-02-26T08:14:40","modified_gmt":"2021-02-26T08:14:40","slug":"switch","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/switch\/","title":{"rendered":"SI.MULTIPLE"},"content":{"rendered":"

Description et syntaxe de la fonction<\/h2>\n

La fonction SI.MULTIPLE, \u00e9quivalente \u00e0 SWITCH dans les versions anglaises d’Excel, permet de comparer une variable \u00e0 une liste de valeurs pr\u00e9d\u00e9finies, et renvoie un r\u00e9sultat correspondant \u00e0 la premi\u00e8re valeur correspondante trouv\u00e9e. Si aucune valeur correspondante n’est trouv\u00e9e, elle peut renvoyer une valeur par d\u00e9faut sp\u00e9cifi\u00e9e par l’utilisateur.<\/p>\n

La syntaxe de la fonction SI.MULTIPLE est la suivante :<\/p>\n

=SI.MULTIPLE(expression, valeur1, r\u00e9sultat1, [valeur2, r\u00e9sultat2, ...], [valeur_par_d\u00e9faut])<\/code><\/pre>\n
Les param\u00e8tres de cette fonction sont d\u00e9finis comme suit :<\/p>\n
    \n
  • expression<\/strong> : L’expression ou la valeur \u00e0 \u00e9valuer et comparer avec la liste de valeurs fournies.<\/li>\n
  • valeur1, valeur2, …<\/strong> : Les valeurs \u00e0 comparer avec l’expression.<\/li>\n
  • r\u00e9sultat1, r\u00e9sultat2, …<\/strong> : Les r\u00e9sultats correspondants qui seront renvoy\u00e9s si une correspondance est trouv\u00e9e entre l’expression et la valeur.<\/li>\n
  • valeur_par_d\u00e9faut<\/strong> (optionnelle) : La valeur qui sera renvoy\u00e9e si aucune des valeurs sp\u00e9cifi\u00e9es ne correspond \u00e0 l’expression. Si ce param\u00e8tre est omis, la fonction renvoie #N\/A en l’absence de correspondance.<\/li>\n<\/ul>\n
    Exemples d’application pratique<\/h2>\n
    Voici quelques exemples illustrant l’utilisation de la fonction SI.MULTIPLE dans des sc\u00e9narios concrets.<\/p>\n
    Cas pratique 1 : Attribution de commentaires bas\u00e9s sur les notes<\/h2>\n
    Consid\u00e9rez l’exemple d’un enseignant souhaitant attribuer automatiquement des commentaires selon les notes des \u00e9l\u00e8ves :<\/p>\n\n\n\n
    Note<\/th>\nCommentaire<\/th>\n<\/tr>\n
    =SI.MULTIPLE(A2, 90, \"Excellent\", 80, \"Tr\u00e8s bien\", 70, \"Bien\", 60, \"Suffisant\", \"\u00c0 am\u00e9liorer\")<\/code><\/td>\nCette formule analyse la note dans la cellule A2 et attribue un commentaire appropri\u00e9.<\/td>\n<\/tr>\n<\/table>\n
    Si la note dans A2 est 85, la formule retournera \u00ab\u00a0Tr\u00e8s bien\u00a0\u00bb. Si elle est en dessous de 60, le commentaire \u00ab\u00a0\u00c0 am\u00e9liorer\u00a0\u00bb sera utilis\u00e9.<\/p>\n
    Cas pratique 2 : Tarification bas\u00e9e sur des tranches de quantit\u00e9<\/h2>\n
    Un commer\u00e7ant peut se servir de la fonction SI.MULTIPLE pour ajuster ses prix en fonction de la quantit\u00e9 achet\u00e9e :<\/p>\n
    =SI.MULTIPLE(B2, 100, 0.95, 50, 0.97, 10, 0.99, 1.00)<\/code><\/pre>\n
    Dans cet exemple, B2 indique la quantit\u00e9 command\u00e9e. La formule applique un coefficient diff\u00e9rent selon la tranche de quantit\u00e9 :<\/p>\n
      \n
    • Pour 100 unit\u00e9s ou plus, le prix par unit\u00e9 est multipli\u00e9 par 0.95.<\/li>\n
    • Pour 50 unit\u00e9s ou plus (mais moins de 100), le prix est de 0.97 par unit\u00e9, et ainsi de suite.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      \u00c9value une expression par rapport \u00e0 une liste de valeurs et renvoie le r\u00e9sultat correspondant \u00e0 la premi\u00e8re valeur correspondante S\u2019il n\u2019y a pas de correspondance, une valeur par d\u00e9faut facultative peut \u00eatre renvoy\u00e9e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[313],"tags":[],"class_list":["post-6796","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction SWITCH (SI.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SWITCH (SI.MULTIPLE) 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\/switch\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SWITCH (SI.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SWITCH (SI.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/switch\/\" \/>\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:14:40+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SWITCH (SI.MULTIPLE) 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\/switch\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/switch\/\",\"name\":\"Fonction SWITCH (SI.MULTIPLE) 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:14:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SWITCH (SI.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/switch\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/switch\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/switch\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Logique\",\"item\":\"https:\/\/functiontranslator.com\/fr\/logique\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SI.MULTIPLE\"}]},{\"@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 SWITCH (SI.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SWITCH (SI.MULTIPLE) 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\/switch\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SWITCH (SI.MULTIPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SWITCH (SI.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/switch\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SWITCH (SI.MULTIPLE) 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\/switch\/","url":"https:\/\/functiontranslator.com\/fr\/switch\/","name":"Fonction SWITCH (SI.MULTIPLE) 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:14:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SWITCH (SI.MULTIPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/switch\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/switch\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/switch\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Logique","item":"https:\/\/functiontranslator.com\/fr\/logique\/"},{"@type":"ListItem","position":3,"name":"SI.MULTIPLE"}]},{"@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\/6796","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=6796"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6796\/revisions"}],"predecessor-version":[{"id":29805,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6796\/revisions\/29805"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}