{"id":6587,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/fonction-si-conditions\/"},"modified":"2021-02-26T08:07:38","modified_gmt":"2021-02-26T08:07:38","slug":"ifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/ifs\/","title":{"rendered":"si. conditions"},"content":{"rendered":"

La fonction IFS dans Microsoft Excel et Google Sheets est une fonction tr\u00e8s utile pour les analyses conditionnelles. Elle permet de v\u00e9rifier plusieurs conditions en une seule expression et de renvoyer une valeur pour la premi\u00e8re condition qui est vraie, simplifiant ainsi la n\u00e9cessit\u00e9 de cha\u00eener plusieurs fonctions SI.<\/p>\n

Syntaxe de la fonction IFS<\/h2>\n

La syntaxe de base de cette fonction est :<\/p>\n

IFS(condition1, valeur1, condition2, valeur2, ..., conditionN, valeurN)<\/code><\/pre>\n
Voici les composants de cette fonction :<\/p>\n
    \n
  • condition1, condition2, …, conditionN<\/strong> : Ce sont les conditions que vous souhaitez \u00e9valuer. Ces conditions peuvent \u00eatre des comparaisons ou tout autre crit\u00e8re qui renvoie TRUE ou FALSE.<\/li>\n
  • valeur1, valeur2, …, valeurN<\/strong> : Ce sont les valeurs renvoy\u00e9es par la fonction si leur condition correspondante est vraie.<\/li>\n<\/ul>\n
    Notez que la fonction renvoie une valeur d\u00e8s la premi\u00e8re condition rencontr\u00e9e qui \u00e9value \u00e0 TRUE et ignore les conditions suivantes.<\/p>\n
    Exemples d’utilisation de la fonction<\/h2>\n
    Consid\u00e9rons un sc\u00e9nario simple o\u00f9 vous avez une liste de notes et vous souhaitez attribuer des mentions selon ces notes :<\/p>\n
    IFS(A1>=90, \"Excellent\", A1>=80, \"Tr\u00e8s Bien\", A1>=70, \"Bien\", A1>=60, \"Satisfaisant\", TRUE, \"Insuffisant\")<\/code><\/pre>\n
    Dans cet exemple, si la note en A1<\/code> est 90 ou plus, la fonction renvoie \u00ab\u00a0Excellent\u00a0\u00bb. Si la note est 80 ou plus mais moins que 90, elle renvoie \u00ab\u00a0Tr\u00e8s Bien\u00a0\u00bb, et ainsi de suite jusqu’\u00e0 \u00ab\u00a0Insuffisant\u00a0\u00bb si aucune des autres conditions n’est remplie.<\/p>\n
    Applications pratiques de l’outil<\/h2>\n
    \u00c9valuation des performances des employ\u00e9s<\/h2>\n
    Imaginons que vous ayez les scores d’\u00e9valuation des employ\u00e9s et que vous vouliez leur attribuer un niveau de performance :<\/p>\n
    IFS(B2>=85, \"Exceptionnel\", B2>=75, \"Sup\u00e9rieur\", B2>=65, \"Moyen\", B2>=55, \"Inf\u00e9rieur\", TRUE, \"\u00c0 am\u00e9liorer\")<\/code><\/pre>\n
    Dans ce tableau, B2 repr\u00e9sente le score d’un employ\u00e9. Chaque score correspond \u00e0 une cat\u00e9gorie de performance. La fonction permet de rapidement cat\u00e9goriser chaque employ\u00e9 en fonction de son score.<\/p>\n
    Gestion d’un inventaire<\/h2>\n
    Supposons que vous g\u00e9rez un inventaire et que vous souhaitez identifier les niveaux de stock :<\/p>\n
    IFS(C2<=20, \"Commander imm\u00e9diatement\", C2<=50, \"Faible\", C2<=100, \"Moder\u00e9\", TRUE, \"Suffisant\")<\/code><\/pre>\n
    Ici, C2 est le niveau de stock d’un article sp\u00e9cifique. Cette formule vous aide \u00e0 automatiser l’alerte de niveau de stock, rendant la gestion de l’inventaire plus efficace.<\/p>\n
    Ces exemples illustrent comment la fonction IFS peut \u00eatre utilis\u00e9e pour am\u00e9liorer la prise de d\u00e9cision en automatisant des analyses conditionnelles, que ce soit dans l’\u00e9ducation, les ressources humaines, ou encore la gestion des stocks.<\/p>\n","protected":false},"excerpt":{"rendered":"
    V\u00e9rifie si une ou plusieurs conditions sont remplies et renvoie une valeur correspondant \u00e0 la premi\u00e8re condition VRAI<\/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-6587","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction IFS (si. conditions) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction IFS (si. conditions) 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\/ifs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction IFS (si. conditions) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction IFS (si. conditions) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/ifs\/\" \/>\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:38+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction IFS (si. conditions) 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\/ifs\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ifs\/\",\"name\":\"Fonction IFS (si. conditions) 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:38+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction IFS (si. conditions) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ifs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ifs\/#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. conditions\"}]},{\"@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 IFS (si. conditions) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction IFS (si. conditions) 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\/ifs\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction IFS (si. conditions) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction IFS (si. conditions) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:07:38+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction IFS (si. conditions) 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\/ifs\/","url":"https:\/\/functiontranslator.com\/fr\/ifs\/","name":"Fonction IFS (si. conditions) 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:38+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction IFS (si. conditions) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ifs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ifs\/#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. conditions"}]},{"@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\/6587","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=6587"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6587\/revisions"}],"predecessor-version":[{"id":29598,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6587\/revisions\/29598"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}