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

Description du fonctionnement<\/h2>\n

La fonction NON<\/code> dans Excel et Google Sheets permet d’inverser la valeur de v\u00e9rit\u00e9 d’un argument. Si l’argument est vrai, la fonction renvoie faux, et vice versa. Cette fonction op\u00e8re comme un op\u00e9rateur de n\u00e9gation logique.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction NON<\/code> est identique dans Excel et Google Sheets :<\/p>\n

NON(logique)<\/code><\/pre>\n
o\u00f9 logique<\/i> est l\u2019argument, habituellement une expression ou une r\u00e9f\u00e9rence de cellule qui renvoie VRAI ou FAUX.<\/p>\n
Exemples d’utilisation<\/h2>\n\n\n\n\n\n\n
Formula<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
=NON(VRAI)<\/code><\/td>\nInverse la valeur VRAI.<\/td>\nFAUX<\/td>\n<\/tr>\n
=NON(FAUX)<\/code><\/td>\nInverse la valeur FAUX.<\/td>\nVRAI<\/td>\n<\/tr>\n
=NON(1=1)<\/code><\/td>\n\u00c9value si 1 n’est pas \u00e9gal \u00e0 1 (faux).<\/td>\nFAUX<\/td>\n<\/tr>\n
=NON(1=2)<\/code><\/td>\n\u00c9value si 1 n’est pas \u00e9gal \u00e0 2 (vrai).<\/td>\nVRAI<\/td>\n<\/tr>\n<\/table>\n
Pratiques applicatives<\/h2>\n
La fonction NON<\/code> est particuli\u00e8rement utile dans divers sc\u00e9narios, notamment dans les tests conditionnels.<\/p>\n
Sc\u00e9nario 1: Filtration des donn\u00e9es<\/h2>\n
Consid\u00e9rez une liste d’\u00e9tudiants avec leurs r\u00e9sultats d’examen. Pour identifier ceux qui n’ont pas r\u00e9ussi, utilisez NON<\/code> si la colonne B indique les r\u00e9sultats (True pour r\u00e9ussi, False pour \u00e9chou\u00e9) :<\/p>\n
=SI(NON(B2); \"Revoir\"; \"Pass\u00e9\")<\/code><\/pre>\n
Dans cet exemple, si B2 contient FAUX (l’\u00e9tudiant a \u00e9chou\u00e9), NON(B2)<\/code> devient VRAI, et la fonction SI<\/code> renvoie \u00ab\u00a0Revoir\u00a0\u00bb.<\/p>\n
Sc\u00e9nario 2: Combiner avec d’autres fonctions logiques<\/h2>\n
Pour v\u00e9rifier qu’un nombre n’est ni dans l’intervalle 1 \u00e0 10, ni n\u00e9gatif, combinez NON<\/code> avec les fonctions ET<\/code> et OU<\/code> :<\/p>\n
=NON(OU(ET(A2>=1; A2<=10); A2<0))<\/code><\/pre>\n
Cette formule est d\u00e9compos\u00e9e comme suit :<\/p>\n
    \n
  • ET(A2>=1; A2<=10)<\/code> v\u00e9rifie si A2 est entre 1 et 10.<\/li>\n
  • A2<0<\/code> confirme si A2 est n\u00e9gatif.<\/li>\n
  • OU<\/code> est vrai si l’une de ces conditions est remplie.<\/li>\n
  • NON<\/code> renverse le r\u00e9sultat de OU<\/code>.<\/li>\n<\/ul>\n
    Cette formule peut \u00eatre utilis\u00e9e pour exclure des valeurs sp\u00e9cifiques lors de l’\u00e9valuation de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Inverse la logIque de cet argument<\/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-6692","post","type-post","status-publish","format-standard","hentry","category-logique"],"acf":[],"yoast_head":"\nFonction NOT (NON) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction NOT (NON) 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\/not\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction NOT (NON) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction NOT (NON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/not\/\" \/>\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:07+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction NOT (NON) 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\/not\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/not\/\",\"name\":\"Fonction NOT (NON) 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:07+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction NOT (NON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/not\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/not\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/not\/#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\":\"NON\"}]},{\"@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 NOT (NON) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction NOT (NON) 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\/not\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction NOT (NON) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction NOT (NON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/not\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:07+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction NOT (NON) 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\/not\/","url":"https:\/\/functiontranslator.com\/fr\/not\/","name":"Fonction NOT (NON) 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:07+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction NOT (NON) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/not\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/not\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/not\/#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":"NON"}]},{"@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\/6692","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=6692"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6692\/revisions"}],"predecessor-version":[{"id":29703,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6692\/revisions\/29703"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}