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

Fonction ESTVIDE<\/h2>\n

La fonction ESTVIDE est essentielle dans le domaine de l\u2019informatique d\u00e9cisionnelle pour identifier les cellules non remplies au sein d’un ensemble de donn\u00e9es, que ce soit dans Microsoft Excel ou Google Sheets. Cette fonction renvoie VRAI si la cellule examin\u00e9e est vide, c\u2019est-\u00e0-dire qu\u2019elle ne contient aucune donn\u00e9e, et FAUX dans le cas contraire.<\/p>\n

Syntaxe et exemples<\/h2>\n

Syntaxe de la fonction :<\/p>\n

=ESTVIDE(cellule)<\/code><\/pre>\n
Prenons l’exemple suivant pour illustrer son utilisation :<\/p>\n
    \n
  • Cellule A1: \u00ab\u00a0Bonjour\u00a0\u00bb<\/li>\n
  • Cellule A2: \u00ab\u00a0\u00a0\u00bb (vide)<\/li>\n
  • Cellule A3: 0<\/li>\n
  • Cellule A4: =ESTVIDE(A2)<\/li>\n<\/ul>\n
    Appliquer la formule =ESTVIDE(A1)<\/code> dans la cellule A4 renverrait FAUX<\/strong>, car A1 contient du texte.<\/p>\n
    En revanche, l’utilisation de =ESTVIDE(A2)<\/code> dans une cellule renverrait VRAI<\/strong>, puisque A2 est vide.<\/p>\n
    De m\u00eame, la formule =ESTVIDE(A3)<\/code> produirait FAUX<\/strong> ; bien que A3 contienne la valeur 0, elle est consid\u00e9r\u00e9e comme une donn\u00e9e.<\/p>\n
    Cas pratiques d’utilisation<\/h2>\n
    Nettoyage des donn\u00e9es<\/h2>\n
    Imaginez un classeur Excel ou une feuille Google comportant des colonnes avec des entr\u00e9es utilisateur susceptibles d’inclure des cellules vides. Pour \u00e9purar ces donn\u00e9es et rep\u00e9rer les entr\u00e9es incompl\u00e8tes, employez la formule suivante :<\/p>\n
    =SI(ESTVIDE(A1), \"Compl\u00e9ter l\u2019information\", \"Information compl\u00e8te\")<\/code><\/pre>\n
    Si A1 est vide, cette formule affichera \u00ab\u00a0Compl\u00e9ter l\u2019information\u00a0\u00bb. Si A1 contient des donn\u00e9es, elle indiquera \u00ab\u00a0Information compl\u00e8te\u00a0\u00bb.<\/p>\n
    Filtrage de donn\u00e9es<\/h2>\n
    Dans le contexte d\u2019une base de donn\u00e9es, il peut \u00eatre n\u00e9cessaire d\u2019effectuer des op\u00e9rations uniquement sur des cellules remplies. Par exemple, pour \u00e9valuer une cellule avant d’effectuer une op\u00e9ration, utilisez :<\/p>\n
    =SI(ESTVIDE(B2), \"\", B2*10)<\/code><\/pre>\n
    Cette formule v\u00e9rifie si B2 est vide. Si c’est le cas, elle renvoie une cellule vide. Sinon, elle multiplie la valeur de B2 par 10.<\/p>\n
    Conclusion<\/h2>\n
    Simple mais fondamentale, la fonction ESTVIDE joue un r\u00f4le crucial dans la gestion des donn\u00e9es manquantes dans les feuilles de calcul. Elle est particuli\u00e8rement utile pour effectuer des contr\u00f4les pr\u00e9liminaires avant des op\u00e9rations ou des analyses plus approfondies, et s’av\u00e8re indispensable pour la manipulation de donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie VRAI si l\u2019aRgument valeuR est vide<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[319],"tags":[],"class_list":["post-6621","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction ISBLANK (ESTVIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ISBLANK (ESTVIDE) 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\/isblank\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ISBLANK (ESTVIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ISBLANK (ESTVIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/isblank\/\" \/>\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:08: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 ISBLANK (ESTVIDE) 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\/isblank\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/isblank\/\",\"name\":\"Fonction ISBLANK (ESTVIDE) 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:08:48+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ISBLANK (ESTVIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/isblank\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/isblank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/isblank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informations\",\"item\":\"https:\/\/functiontranslator.com\/fr\/informations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ESTVIDE\"}]},{\"@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 ISBLANK (ESTVIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ISBLANK (ESTVIDE) 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\/isblank\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ISBLANK (ESTVIDE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ISBLANK (ESTVIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/isblank\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:48+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ISBLANK (ESTVIDE) 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\/isblank\/","url":"https:\/\/functiontranslator.com\/fr\/isblank\/","name":"Fonction ISBLANK (ESTVIDE) 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:08:48+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ISBLANK (ESTVIDE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/isblank\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/isblank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/isblank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Informations","item":"https:\/\/functiontranslator.com\/fr\/informations\/"},{"@type":"ListItem","position":3,"name":"ESTVIDE"}]},{"@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\/6621","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=6621"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6621\/revisions"}],"predecessor-version":[{"id":29632,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6621\/revisions\/29632"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}