{"id":6706,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/ou\/"},"modified":"2021-02-26T08:11:30","modified_gmt":"2021-02-26T08:11:30","slug":"or","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/or\/","title":{"rendered":"OU"},"content":{"rendered":"

Description et syntaxe<\/h2>\n

La fonction OU (OR en anglais) appartient aux fonctions logiques d\u2019Excel et Google Sheets. Elle est utilis\u00e9e pour \u00e9valuer plusieurs conditions et renvoie VRAI si au moins une de ces conditions est vraie. Si aucune condition n\u2019est satisfaite, la fonction renvoie FAUX. Elle est particuli\u00e8rement utile pour les prises de d\u00e9cision qui d\u00e9pendent de multiples crit\u00e8res.<\/p>\n

Voici la syntaxe de la fonction OU :<\/p>\n

OU(condition1, [condition2], ...)<\/code><\/pre>\n
O\u00f9 condition1<\/code>, condition2<\/code>, etc., repr\u00e9sentent les conditions \u00e0 tester. La fonction peut accepter jusqu’\u00e0 255 conditions dans Microsoft Excel et 30 conditions dans Google Sheets.<\/p>\n
Exemple d’utilisation<\/h2>\n
Imaginons que vous disposiez d’une liste d’\u00e9tudiants avec leurs scores pour deux tests. Vous souhaitez savoir si un \u00e9tudiant a r\u00e9ussi en obtenant au moins 50 points sur l’un des deux tests. Les scores sont r\u00e9partis dans deux colonnes A et B, chaque ligne repr\u00e9sentant un \u00e9tudiant avec Test1 en A et Test2 en B :<\/p>\n
A B Test1 Test2 40 55 45 45 60 30<\/code><\/pre>\n
Pour utiliser la fonction OU, vous ins\u00e9reriez la formule suivante en C2 :<\/p>\n
 =OU(A2>=50; B2>=50)<\/code> <\/p>\n
Etendez cette formule vers le bas pour couvrir les autres cellules. Voici les r\u00e9sultats obtenus :<\/p>\n
C FAUX FAUX VRAI<\/code><\/pre>\n
Cela montre que seul le troisi\u00e8me \u00e9tudiant a r\u00e9ussi l’un des tests.<\/p>\n
Applications pratiques<\/h2>\n
Voici quelques sc\u00e9narios o\u00f9 la fonction OU peut \u00eatre extr\u00eamement utile :<\/p>\n
Analyser l’admissibilit\u00e9 aux avantages<\/h3>\n
Consid\u00e9rons une entreprise qui offre un bonus de fid\u00e9lit\u00e9 bas\u00e9 soit sur l’anciennet\u00e9 soit sur la performance des employ\u00e9s. Les conditions sont soit plus de 5 ans de service, soit un score d’\u00e9valuation sup\u00e9rieur \u00e0 80 points. Supposons que les donn\u00e9es soient structur\u00e9es comme suit :<\/p>\n
Nom Anciennet\u00e9 Score John 3 90 Lila 6 75 Eve 4 85<\/code><\/pre>\n
La formule suivante \u00e0 entrer en C2 permettrait de d\u00e9terminer l’\u00e9ligibilit\u00e9 au bonus :<\/p>\n
 =OU(B2>5; C2>80)<\/code> <\/p>\n
\u00c9tendez cette formule aux cellules suivantes pour voir qui remplit les crit\u00e8res.<\/p>\n
Validation de saisie<\/h3>\n
Supposez que dans un formulaire, vous exigez que l’utilisateur remplisse au moins un des deux champs t\u00e9l\u00e9phoniques (principal ou secondaire). La fonction OU peut \u00eatre employ\u00e9e pour s’assurer qu’au moins une information a \u00e9t\u00e9 saisie. Par exemple :<\/p>\n
T\u00e9l\u00e9phone Principal T\u00e9l\u00e9phone Secondaire 123456789 (vide) (vide) 987654321 (vide) (vide)<\/code><\/pre>\n
La formule appliqu\u00e9e en C2 serait :<\/p>\n
 =OU(A2<>\"\"; B2<>\"\")<\/code> <\/p>\n
Un r\u00e9sultat VRAI indiquerait qu’au moins un des champs est correctement rempli.<\/p>\n
Ces exemples illustrent la polyvalence et l’efficacit\u00e9 de la fonction OU pour diverses situations n\u00e9cessitant des d\u00e9cisions logiques dans les feuilles de calcul. Utiliser cette fonction judicieusement peut simplifier vos formules et optimiser vos analyses.<\/p>\n","protected":false},"excerpt":{"rendered":"
Renvoie VRAI si un des aRguments est 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-6706","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction OR (OU) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction OR (OU) 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\/or\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction OR (OU) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction OR (OU) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/or\/\" \/>\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:11:30+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction OR (OU) 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\/or\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/or\/\",\"name\":\"Fonction OR (OU) 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:11:30+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction OR (OU) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/or\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/or\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/or\/#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\":\"OU\"}]},{\"@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 OR (OU) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction OR (OU) 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\/or\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction OR (OU) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction OR (OU) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/or\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:30+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction OR (OU) 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\/or\/","url":"https:\/\/functiontranslator.com\/fr\/or\/","name":"Fonction OR (OU) 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:11:30+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction OR (OU) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/or\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/or\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/or\/#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":"OU"}]},{"@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\/6706","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=6706"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6706\/revisions"}],"predecessor-version":[{"id":29717,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6706\/revisions\/29717"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}