{"id":6850,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/oux\/"},"modified":"2021-02-26T08:16:31","modified_gmt":"2021-02-26T08:16:31","slug":"xor","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/xor\/","title":{"rendered":"OUX"},"content":{"rendered":"

La fonction XOR (OUX en fran\u00e7ais) est une fonction logique utilis\u00e9e couramment dans Microsoft Excel et Google Sheets. Elle renvoie TRUE si le nombre de valeurs TRUE est impair, et FALSE si ce nombre est pair. Cette fonction est particuli\u00e8rement pratique pour effectuer des tests logiques comprenant plusieurs conditions vari\u00e9es.<\/p>\n

Syntaxe et exemples dans Excel et Google Sheets<\/h2>\n

La syntaxe de la fonction XOR est la suivante :<\/p>\n

=XOR(logical1, [logical2], ...)<\/code><\/pre>\n
    \n
  • logical1, logical2, …<\/strong> : Ce sont les arguments qui repr\u00e9sentent les conditions \u00e0 v\u00e9rifier. Il est n\u00e9cessaire de fournir au moins un argument. Chaque argument peut \u00eatre soit une expression logique, soit une r\u00e9f\u00e9rence \u00e0 une cellule contenant une telle expression.<\/li>\n<\/ul>\n
    Voici un exemple simple :<\/p>\n
    =XOR(A2 = 5, B2 > 3)<\/code><\/pre>\n
    Prenons le cas o\u00f9 A2 \u00e9quivaut \u00e0 5 et B2 \u00e0 4. La formule XOR renverrait FALSE car les deux conditions sont TRUE (5 est \u00e9gal \u00e0 5 et 4 est plus grand que 3).<\/p>\n
    Sc\u00e9narios d’application pratiques<\/h2>\n
    Exemple 1: Contr\u00f4le de la saisie des donn\u00e9es<\/h2>\n
    Imaginez une feuille de calcul o\u00f9 certaines conditions doivent \u00eatre mutuellement exclusives pour valider une inscription. Par exemple, deux champs intitul\u00e9s \u00ab\u00a0Accepte_email\u00a0\u00bb en A2 et \u00ab\u00a0Accepte_SMS\u00a0\u00bb en B2 ne devraient pas \u00eatre tous les deux sur \u00ab\u00a0Oui\u00a0\u00bb. La formule XOR peut \u00eatre utilis\u00e9e pour garantir qu’une seule de ces options soit s\u00e9lectionn\u00e9e :<\/p>\n
    =XOR(A2 = \"Oui\", B2 = \"Oui\")<\/code><\/pre>\n
    Si les deux conditions sont TRUE ou si toutes les deux sont FALSE, la formule renverra FALSE, indiquant une erreur de saisie. Si l’une est TRUE et l’autre FALSE, elle renverra TRUE, montrant que la saisie est correcte.<\/p>\n
    Exemple 2: \u00c9valuation de l’admissibilit\u00e9<\/h2>\n
    Consid\u00e9rons une situation o\u00f9 un \u00e9tudiant est \u00e9ligible \u00e0 une bourse uniquement si l’un des deux crit\u00e8res suivants est respect\u00e9, mais pas les deux : avoir moins de 20 ans ou des revenus familiaux inf\u00e9rieurs \u00e0 un certain seuil. Admettons que l’\u00e2ge de l’\u00e9tudiant soit dans la cellule A3 et que les revenus familiaux figurent dans B3 :<\/p>\n
    =XOR(A3 < 20, B3 < 50000)<\/code><\/pre>\n
    La fonction XOR simplifie ici la logique en renvoyant TRUE seulement si un des deux crit\u00e8res est rempli, mais pas les deux.<\/p>\n
    En conclusion, la fonction XOR est un outil extr\u00eamement utile pour g\u00e9rer des validations logiques bas\u00e9es sur des conditions exclusivement multiples, et elle est tr\u00e8s utile dans la gestion de feuilles de calcul complexes o\u00f9 de telles conditions doivent \u00eatre abord\u00e9es efficacement.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un OU exclusif logique de tous les arguments<\/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-6850","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction XOR (OUX) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction XOR (OUX) 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\/xor\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction XOR (OUX) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction XOR (OUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/xor\/\" \/>\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:16: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 XOR (OUX) 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\/xor\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/xor\/\",\"name\":\"Fonction XOR (OUX) 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:16:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction XOR (OUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/xor\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/xor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/xor\/#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\":\"OUX\"}]},{\"@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 XOR (OUX) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction XOR (OUX) 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\/xor\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction XOR (OUX) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction XOR (OUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/xor\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction XOR (OUX) 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\/xor\/","url":"https:\/\/functiontranslator.com\/fr\/xor\/","name":"Fonction XOR (OUX) 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:16:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction XOR (OUX) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/xor\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/xor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/xor\/#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":"OUX"}]},{"@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\/6850","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=6850"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6850\/revisions"}],"predecessor-version":[{"id":29859,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6850\/revisions\/29859"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}