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

La fonction ET est essentielle dans Excel et Google Sheets pour \u00e9valuer la v\u00e9racit\u00e9 de plusieurs crit\u00e8res simultan\u00e9s. Si chaque condition sp\u00e9cifi\u00e9e dans une formule ET est remplie, la fonction renvoie \u00ab\u00a0VRAI\u00a0\u00bb, dans le cas contraire, elle retourne \u00ab\u00a0FAUX\u00a0\u00bb. Cette fonction est particuli\u00e8rement utile dans de nombreux sc\u00e9narios comme le filtrage de donn\u00e9es, la v\u00e9rification de conformit\u00e9 ou l’\u00e9laboration de conditions complexes dans des mod\u00e8les financiers, pour n’en citer que quelques-uns.<\/p>\n

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

La syntaxe de la fonction ET reste identique que ce soit dans Excel ou Google Sheets :<\/p>\n

=ET(logique1; [logique2]; ...)<\/code><\/pre>\n
    \n
  • logique1, logique2, …<\/strong> : Ce sont les conditions \u00e0 tester. Vous pouvez ins\u00e9rer plusieurs arguments logiques. Si l\u2019un des arguments est FAUX, alors la fonction ET retourne FAUX.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n\n\n\n\n\n
    Formule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    =ET(VRAI, VRAI)<\/code><\/td>\nVRAI<\/td>\n<\/tr>\n
    =ET(VRAI, FAUX)<\/code><\/td>\nFAUX<\/td>\n<\/tr>\n
    =ET(1+1=2, 2+2=4)<\/code><\/td>\nVRAI<\/td>\n<\/tr>\n<\/table>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Cas pratique 1 : Validation de crit\u00e8res multiples<\/h2>\n
    Consid\u00e9rons une liste d’employ\u00e9s avec les heures travaill\u00e9es et les taux horaires enregistr\u00e9s. Vous souhaitez identifier ceux qui ont travaill\u00e9 plus de 40 heures et dont le taux horaire exc\u00e8de 50 \u20ac.<\/p>\n
    Employ\u00e9 Heures Taux horaire Alice 45 55 Bob 38 60 Charlie 42 49 Diane 41 52<\/code><\/pre>\n
    Utilisez la fonction ET pour filtrer ces donn\u00e9es :<\/p>\n
    =ET(B2>40; C2>50)<\/code><\/pre>\n
    En appliquant cette formule dans la colonne adjacente (supposons la colonne D), les r\u00e9sultats seraient :<\/p>\n
    D2: VRAI D3: FAUX D4: FAUX D5: VRAI<\/code><\/pre>\n
    Cette formule montre que seules Alice et Diane satisfont aux deux crit\u00e8res.<\/p>\n
    Cas pratique 2 : Conditions dans une fonction SI<\/h2>\n
    Supposez maintenant que vous devez attribuer un bonus de 10 % aux ventes des employ\u00e9s qui ont \u00e0 la fois d\u00e9pass\u00e9 100 unit\u00e9s vendues et obtenu un taux de satisfaction client sup\u00e9rieur \u00e0 90 %.<\/p>\n
    Employ\u00e9 Unit\u00e9s vendues Satisfaction (%) Alice 105 92 Bob 110 89 Charlie 102 91<\/code><\/pre>\n
    La formule pour calculer leur bonus serait :<\/p>\n
    =SI(ET(B2>100; C2>90); B2*0.1; 0)<\/code><\/pre>\n
    Cela signifie qu’un employ\u00e9 re\u00e7oit un bonus de 10 % sur ses ventes si ses unit\u00e9s vendues d\u00e9passent 100 et que son taux de satisfaction est au-dessus de 90 % ; aucun bonus n’est attribu\u00e9 dans les autres cas.<\/p>\n
    D2: 10.5 D3: 0 D4: 10.2<\/code><\/pre>\n
    Ici, Alice et Charlie obtiennent un bonus, mais pas Bob, car malgr\u00e9 un volume de ventes \u00e9lev\u00e9, son taux de satisfaction est inf\u00e9rieur \u00e0 90 %.<\/p>\n
    Ces exemples illustrent la capacit\u00e9 de la fonction ET \u00e0 int\u00e9grer plusieurs conditions, cr\u00e9ant ainsi des formules robustes pour l’analyse de donn\u00e9es professionnelles et autres calculs complexes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie VRAI si tous ses aRguments sont 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-6388","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction AND (ET) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction AND (ET) 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\/and\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction AND (ET) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction AND (ET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/and\/\" \/>\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:01:48+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction AND (ET) 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\/and\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/and\/\",\"name\":\"Fonction AND (ET) 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:01:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction AND (ET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/and\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/and\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/and\/#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\":\"ET\"}]},{\"@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 AND (ET) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction AND (ET) 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\/and\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction AND (ET) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction AND (ET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/and\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:01:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction AND (ET) 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\/and\/","url":"https:\/\/functiontranslator.com\/fr\/and\/","name":"Fonction AND (ET) 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:01:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction AND (ET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/and\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/and\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/and\/#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":"ET"}]},{"@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\/6388","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=6388"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6388\/revisions"}],"predecessor-version":[{"id":29400,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6388\/revisions\/29400"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}