{"id":6584,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/si\/"},"modified":"2021-02-26T08:07:31","modified_gmt":"2021-02-26T08:07:31","slug":"if","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/if\/","title":{"rendered":"SI"},"content":{"rendered":"<h2>Introduction \u00e0 la fonction Conditionnelle SI<\/h2>\n<p>La fonction SI est indispensable en Excel et Google Sheets pour r\u00e9aliser des op\u00e9rations logiques. Elle compare une valeur donn\u00e9e \u00e0 une condition attendue, renvoyant un r\u00e9sultat si la condition est remplie et un autre si elle ne l&rsquo;est pas.<\/p>\n<h2>Syntaxe et Exemples<\/h2>\n<p>Voici la syntaxe de la fonction SI :<\/p>\n<pre><code>SI(condition; valeur_si_vrai; valeur_si_faux)<\/code><\/pre>\n<p>D\u00e9tail de la syntaxe :<\/p>\n<ul>\n<li><strong>condition<\/strong> : Teste si cette expression est vraie ou fausse.<\/li>\n<li><strong>valeur_si_vrai<\/strong> : R\u00e9sultat renvoy\u00e9 si la condition est vraie.<\/li>\n<li><strong>valeur_si_faux<\/strong> : R\u00e9sultat renvoy\u00e9 si la condition est fausse.<\/li>\n<\/ul>\n<p>Exemple en Excel :<\/p>\n<pre><code>=SI(A1 > 0; \"Positif\"; \"N\u00e9gatif\")<\/code><\/pre>\n<p>Cet exemple \u00e9value si la valeur dans la cellule A1 est sup\u00e9rieure \u00e0 z\u00e9ro, renvoyant &lsquo;Positif&rsquo; si vrai, et &lsquo;N\u00e9gatif&rsquo; autrement.<\/p>\n<p>Exemple en Google Sheets :<\/p>\n<pre><code>=SI(A1 <= 10; \"Inf\u00e9rieur ou \u00e9gal \u00e0 10\"; \"Sup\u00e9rieur \u00e0 10\")<\/code><\/pre>\n<p>Cette formule v\u00e9rifie si la valeur dans la cellule A1 est inf\u00e9rieure ou \u00e9gale \u00e0 10, et renvoie 'Inf\u00e9rieur ou \u00e9gal \u00e0 10' si c'est le cas, sinon 'Sup\u00e9rieur \u00e0 10'.<\/p>\n<h2>Applications pratiques de la fonction SI<\/h2>\n<h2>Cas d'utilisation 1: Attribution de notes<\/h2>\n<p>Consid\u00e9rons un enseignant attribuant automatiquement une note bas\u00e9e sur le pourcentage obtenu par un \u00e9tudiant.<\/p>\n<p>Voici la configuration :<\/p>\n<pre><code>=SI(A1 >= 90; \"A\"; SI(A1 >= 80; \"B\"; SI(A1 >= 70; \"C\"; SI(A1 >= 60; \"D\"; \"F\"))))<\/code><\/pre>\n<p>Dans cet exemple, la fonction SI \u00e9value le pourcentage ins\u00e9r\u00e9 dans la cellule A1 et attribue une note de 'A' \u00e0 'F' en fonction des r\u00e9sultats obtenus.<\/p>\n<h2>Cas d'utilisation 2: Calcul des remises<\/h2>\n<p>Une entreprise d\u00e9termine les remises sur les achats d'un client en fonction du montant total.<\/p>\n<p>Configuration de la formule :<\/p>\n<pre><code>=SI(B1 > 500; B1*0.1; 0)<\/code><\/pre>\n<p>Cette formule donne une remise de 10% si les achats (cellule B1) d\u00e9passent 500. Dans le cas contraire, aucune remise n'est appliqu\u00e9e.<\/p>\n<p>Ces exemples illustrent la polyvalence de la fonction SI pour r\u00e9pondre \u00e0 des besoins conditionnels vari\u00e9s et complexes, permettant une automatisation accrue et une efficacit\u00e9 am\u00e9lior\u00e9e des feuilles de calcul.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sp\u00e9cifie un teSt logique \u00e0 effectuer<\/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-6584","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction IF (SI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction IF (SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/if\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction IF (SI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction IF (SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/if\/\" \/>\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:07:31+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction IF (SI) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/if\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/if\/\",\"name\":\"Fonction IF (SI) 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:07:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction IF (SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/if\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/if\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/if\/#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\"}]},{\"@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 IF (SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction IF (SI) 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\/if\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction IF (SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction IF (SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/if\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction IF (SI) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/if\/","url":"https:\/\/functiontranslator.com\/fr\/if\/","name":"Fonction IF (SI) 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:07:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction IF (SI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/if\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/if\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/if\/#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"}]},{"@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\/6584","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=6584"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6584\/revisions"}],"predecessor-version":[{"id":29595,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6584\/revisions\/29595"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}