{"id":6525,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/type-erreur\/"},"modified":"2021-02-26T08:05:49","modified_gmt":"2021-02-26T08:05:49","slug":"error-type","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/error-type\/","title":{"rendered":"TYPE.ERREUR"},"content":{"rendered":"

Synth\u00e8se et Usage de la Fonction dans Excel et Google Sheets<\/h2>\n

La fonction ERROR.TYPE (TYPE.ERREUR en fran\u00e7ais) est utilis\u00e9e pour identifier le code num\u00e9rique associ\u00e9 \u00e0 diff\u00e9rents types d’erreurs dans une cellule. Cette fonction est particuli\u00e8rement utile pour le d\u00e9bogage de formules dans vos feuilles de calcul.<\/p>\n

Syntaxe de la Fonction<\/h2>\n

La syntaxe de la fonction ERROR.TYPE est simple :<\/p>\n

=ERROR.TYPE(valeur)<\/code><\/pre>\n
    \n
  • valeur<\/strong> : R\u00e9f\u00e9rence de la cellule pour laquelle le type d’erreur est d\u00e9termin\u00e9. Si la cellule en question ne contient pas d’erreur, la fonction renvoie #N\/A.<\/li>\n<\/ul>\n
    Exemple Simple<\/h2>\n
    Imaginez que la cellule A1 contienne une formule produisant l’erreur #DIV\/0! (division par z\u00e9ro). En appliquant la fonction ERROR.TYPE :<\/p>\n
    =ERROR.TYPE(A1)<\/code><\/pre>\n
    Ceci renverra 2, car 2 est le num\u00e9ro associ\u00e9 \u00e0 l’erreur #DIV\/0! dans Excel et Google Sheets.<\/p>\n
    Applications Pratiques<\/h2>\n
    Voici comment utiliser pratique cette fonction dans des sc\u00e9narios r\u00e9els.<\/p>\n
    Identification des Types d’Erreurs dans un Rapport<\/h2>\n
    Supposez que vous g\u00e9rez une importante base de donn\u00e9es et souhaitez identifier et comptabiliser les divers types d’erreurs dans une colonne sp\u00e9cifique (par exemple, la colonne B).<\/p>\n
    =IF(ISERROR(B1), ERROR.TYPE(B1), \"\")<\/code><\/pre>\n
    Cette formule commence par v\u00e9rifier si B1 contient une erreur, puis utilise ERROR.TYPE pour d\u00e9terminer le type d’erreur. Si aucune erreur n’est d\u00e9tect\u00e9e, la cellule reste vide.<\/p>\n
    Cr\u00e9ation d’un R\u00e9sum\u00e9 d’Erreurs<\/h2>\n
    Pour \u00e9laborer un tableau r\u00e9capitulatif des types d’erreurs et de leur fr\u00e9quence, vous pouvez combiner ERROR.TYPE avec des fonctions telles que les tableaux crois\u00e9s dynamiques ou COUNTIF.<\/p>\n
    Voici un exemple pour \u00e9valuer combien de fois chaque type d’erreur se manifeste :<\/p>\n\n\n\n\n
    Type d’Erreur<\/th>\nFormule<\/th>\n<\/tr>\n
    #DIV\/0!<\/td>\n=COUNTIF(B:B, ERROR.TYPE(B1))<\/td>\n<\/tr>\n
    #N\/A<\/td>\n=COUNTIF(B:B, ERROR.TYPE(B1))<\/td>\n<\/tr>\n<\/table>\n
    Note: Remplacez \u00ab\u00a0B1\u00a0\u00bb dans ERROR.TYPE(B1) par la r\u00e9f\u00e9rence qui convient \u00e0 chaque type d’erreur dans votre cas.<\/p>\n
    En utilisant ces m\u00e9thodes, il est possible de non seulement d\u00e9tecter les erreurs mais aussi d’analyser la qualit\u00e9 des donn\u00e9es, et d’am\u00e9liorer la pr\u00e9cision des contr\u00f4les et des proc\u00e9d\u00e9s de nettoyage des donn\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un nombRe coRRespondant \u00e0 un type d\u2019eRReuR<\/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-6525","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction ERROR.TYPE (TYPE.ERREUR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ERROR.TYPE (TYPE.ERREUR) 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\/error-type\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ERROR.TYPE (TYPE.ERREUR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ERROR.TYPE (TYPE.ERREUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/error-type\/\" \/>\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:05:49+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ERROR.TYPE (TYPE.ERREUR) 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\/error-type\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/error-type\/\",\"name\":\"Fonction ERROR.TYPE (TYPE.ERREUR) 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:05:49+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ERROR.TYPE (TYPE.ERREUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/error-type\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/error-type\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/error-type\/#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\":\"TYPE.ERREUR\"}]},{\"@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 ERROR.TYPE (TYPE.ERREUR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ERROR.TYPE (TYPE.ERREUR) 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\/error-type\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ERROR.TYPE (TYPE.ERREUR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ERROR.TYPE (TYPE.ERREUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/error-type\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:49+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ERROR.TYPE (TYPE.ERREUR) 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\/error-type\/","url":"https:\/\/functiontranslator.com\/fr\/error-type\/","name":"Fonction ERROR.TYPE (TYPE.ERREUR) 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:05:49+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ERROR.TYPE (TYPE.ERREUR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/error-type\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/error-type\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/error-type\/#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":"TYPE.ERREUR"}]},{"@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\/6525","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=6525"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6525\/revisions"}],"predecessor-version":[{"id":29537,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6525\/revisions\/29537"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}