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

La fonction VRAI<\/strong> est extr\u00eamement simple \u00e0 utiliser dans Microsoft Excel et Google Sheets, sans n\u00e9cessiter d\u2019argument, et renvoie la valeur logique VRAI. Cette fonction, bien que fondamentale, est fr\u00e9quemment employ\u00e9e pour effectuer des tests logiques et \u00e9tablir des conditions.<\/p>\n

Explication du fonctionnement<\/h2>\n

La syntaxe de la fonction VRAI est tr\u00e8s \u00e9pur\u00e9e, ne requ\u00e9rant aucun param\u00e8tre. Voici comment l\u2019utiliser :<\/p>\n

=VRAI()<\/code><\/pre>\n
Dans Excel et Google Sheets, cette fonction renvoie simplement la valeur logique VRAI<\/strong>. Elle est couramment utilis\u00e9e dans les formules conditionnelles ou d\u2019autres fonctions n\u00e9cessitant une \u00e9valuation bool\u00e9enne.<\/p>\n
Exemples pratiques d’utilisation<\/h2>\n
Cas d’usage 1: Utilisation dans une fonction SI<\/h2>\n
Supposons que vous disposiez d’une liste ventes et souhaitiez attribuer une prime \u00e0 chaque employ\u00e9 ayant atteint plus de 100 ventes. Pour ce faire, vous pouvez combiner la fonction VRAI avec la fonction SI :<\/p>\n
=SI(B2>100, VRAI(), FAUX())<\/code><\/pre>\n
    \n
  • B2>100<\/strong> : V\u00e9rifie si le nombre de ventes dans la cellule B2 d\u00e9passe 100.<\/li>\n
  • VRAI()<\/strong> : Renvoie VRAI si la condition est satisfaite.<\/li>\n
  • FAUX()<\/strong> : Renvoie FAUX si la condition n’est pas remplie.<\/li>\n<\/ul>\n
    Cette formule d\u00e9termine si un employ\u00e9 a r\u00e9alis\u00e9 plus de 100 ventes, renvoyant TRUE si c\u2019est le cas, et FALSE autrement.<\/p>\n
    Cas d’usage 2: Utilisation avec la fonction ET<\/h2>\n
    Imaginons que vous souhaitiez \u00e9valuer plusieurs conditions avant de prendre une d\u00e9cision. Par exemple, v\u00e9rifier si un \u00e9tudiant a obtenu plus de 50 \u00e0 tous ses examens et a assist\u00e9 \u00e0 plus de 75% de ses cours. Les fonctions VRAI, ET et SI peuvent \u00eatre utilis\u00e9es conjointement :<\/p>\n
    =SI(ET(C2>50, D2>75), VRAI(), FAUX())<\/code><\/pre>\n
      \n
    • C2>50<\/strong> : Contr\u00f4le si la note de l\u2019examen est sup\u00e9rieure \u00e0 50.<\/li>\n
    • D2>75<\/strong> : V\u00e9rifie si le taux de pr\u00e9sence est au-del\u00e0 de 75%.<\/li>\n
    • ET(C2>50, D2>75)<\/code> : Retourne TRUE si toutes les conditions sont remplies.<\/li>\n
    • VRAI()<\/code> : Renvoie TRUE si toutes les conditions sont v\u00e9rifi\u00e9es.<\/li>\n
    • FAUX()<\/code> : Renvoie FALSE si au moins une des conditions n\u2019est pas atteinte.<\/li>\n<\/ul>\n
      Cette formule permet de statuer si un \u00e9tudiant remplit tous les crit\u00e8res requis, illustrant l’efficacit\u00e9 de la fonction VRAI dans des tests impliquant plusieurs crit\u00e8res.<\/p>\n
      En r\u00e9sum\u00e9, m\u00eame si la fonction VRAI peut para\u00eetre \u00e9l\u00e9mentaire, son int\u00e9gration dans diff\u00e9rents contextes peut simplifier les formules de mani\u00e8re significative et am\u00e9liorer la lisibilit\u00e9 et la maintenance des feuilles de calcul.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la valeuR logique 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-6820","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction TRUE (VRAI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TRUE (VRAI) 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\/true\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TRUE (VRAI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TRUE (VRAI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/true\/\" \/>\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:15:37+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TRUE (VRAI) 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\/true\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/true\/\",\"name\":\"Fonction TRUE (VRAI) 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:15:37+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TRUE (VRAI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/true\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/true\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/true\/#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\":\"VRAI\"}]},{\"@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 TRUE (VRAI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TRUE (VRAI) 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\/true\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TRUE (VRAI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TRUE (VRAI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/true\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:37+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TRUE (VRAI) 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\/true\/","url":"https:\/\/functiontranslator.com\/fr\/true\/","name":"Fonction TRUE (VRAI) 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:15:37+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TRUE (VRAI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/true\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/true\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/true\/#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":"VRAI"}]},{"@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\/6820","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=6820"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6820\/revisions"}],"predecessor-version":[{"id":29829,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6820\/revisions\/29829"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}