{"id":6630,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/est-impair\/"},"modified":"2021-02-26T08:09:06","modified_gmt":"2021-02-26T08:09:06","slug":"isodd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/isodd\/","title":{"rendered":"EST.IMPAIR"},"content":{"rendered":"

Introduction \u00e0 la fonction EST.IMPAIR dans Excel et Google Sheets<\/h2>\n

La fonction EST.IMPAIR est utilis\u00e9e pour d\u00e9terminer si un nombre est impair. Elle renvoie TRUE si le nombre est impair et FALSE s’il est pair. Cette fonction est extr\u00eamement utile dans divers sc\u00e9narios, tels que le filtrage ou l’application de conditions sur des donn\u00e9es num\u00e9riques bas\u00e9es sur leur parit\u00e9.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction EST.IMPAIR est la suivante :<\/p>\n

  EST.IMPAIR(nombre) <\/code> <\/pre>\n
Le terme nombre<\/code> fait r\u00e9f\u00e9rence au nombre que vous voulez tester. Cette valeur peut \u00eatre une r\u00e9f\u00e9rence \u00e0 une cellule contenant un nombre, le r\u00e9sultat d’une formule, ou un nombre saisi directement dans l\u2019argument de la fonction.<\/p>\n\n\n\n\n
Exemple<\/th>\nFormule<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
V\u00e9rifier si 7 est impair<\/td>\n=EST.IMPAIR(7)<\/td>\nTRUE<\/td>\n<\/tr>\n
V\u00e9rifier si 6 est impair<\/td>\n=EST.IMPAIR(6)<\/td>\nFALSE<\/td>\n<\/tr>\n<\/table>\n
Utilisations pratiques de la fonction EST.IMPAIR<\/h2>\n
La fonction EST.IMPAIR peut \u00eatre utile dans une vari\u00e9t\u00e9 de situations. Voici deux exemples o\u00f9 elle peut \u00eatre efficacement mise en \u0153uvre :<\/p>\n
    \n
  • Filtrage de donn\u00e9es :<\/strong> Supposons que vous avez une liste de nombres et vous d\u00e9sirez isoler uniquement les nombres impairs. Cette s\u00e9lection peut \u00eatre r\u00e9alis\u00e9e en combinant la fonction EST.IMPAIR avec une fonction conditionnelle pour extraire ces nombres.<\/li>\n
  • Application de formats conditionnels :<\/strong> Vous pouvez \u00e9galement vouloir appliquer un format particulier aux nombres impairs dans une liste pour les distinguer visuellement. Cela peut \u00eatre accompli en utilisant des formats conditionnels qui s\u2019appuient sur la fonction EST.IMPAIR.<\/li>\n<\/ul>\n
    Exemple de t\u00e2che avec solution d\u00e9taill\u00e9e<\/h2>\n
    Imaginez que vous disposez d’une liste de nombres de A1 \u00e0 A10 dans la colonne A, et que vous souhaitez identifier les nombres impairs.<\/p>\n
    Vous pouvez entrer la formule suivante en B1 et la copier vers le bas jusqu’\u00e0 B10 :<\/p>\n
      =EST.IMPAIR(A1) <\/code> <\/pre>\n
    Cela affichera TRUE ou FALSE dans chaque cellule de la colonne B, indiquant si le nombre correspondant dans la colonne A est impair ou non.<\/p>\n
    Maintenant, pour appliquer un format conditionnel aux cellules de la colonne A qui contiennent des nombres impairs, voici la marche \u00e0 suivre :<\/p>\n
      \n
    • S\u00e9lectionnez la plage A1:A10.<\/li>\n
    • Acc\u00e9dez \u00e0 ‘Format’, puis ‘Format conditionnel’.<\/li>\n
    • D\u00e9finissez la r\u00e8gle pour que les cellules soient format\u00e9es si la formule ‘=EST.IMPAIR(A1)<\/code>‘ renvoie TRUE.<\/li>\n
    • Choisissez un style de formatage, tel qu’une couleur de fond diff\u00e9rente, et appliquez le format.<\/li>\n<\/ul>\n
      Cela rendra tous les nombres impairs dans votre liste faciles \u00e0 identifier visuellement.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie VRAI si le chiffRe est impaiR<\/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-6630","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction ISODD (EST.IMPAIR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ISODD (EST.IMPAIR) 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\/isodd\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ISODD (EST.IMPAIR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ISODD (EST.IMPAIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/isodd\/\" \/>\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:09:06+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ISODD (EST.IMPAIR) 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\/isodd\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/isodd\/\",\"name\":\"Fonction ISODD (EST.IMPAIR) 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:09:06+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ISODD (EST.IMPAIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/isodd\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/isodd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/isodd\/#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\":\"EST.IMPAIR\"}]},{\"@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 ISODD (EST.IMPAIR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ISODD (EST.IMPAIR) 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\/isodd\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ISODD (EST.IMPAIR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ISODD (EST.IMPAIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/isodd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:06+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ISODD (EST.IMPAIR) 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\/isodd\/","url":"https:\/\/functiontranslator.com\/fr\/isodd\/","name":"Fonction ISODD (EST.IMPAIR) 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:09:06+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ISODD (EST.IMPAIR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/isodd\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/isodd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/isodd\/#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":"EST.IMPAIR"}]},{"@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\/6630","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=6630"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6630\/revisions"}],"predecessor-version":[{"id":29641,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6630\/revisions\/29641"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}