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

La fonction TYPE est essentielle dans Microsoft Excel et Google Sheets pour identifier le type de donn\u00e9e contenu dans une cellule. Elle renvoie un nombre entier repr\u00e9sentant ce type, ce qui est particuli\u00e8rement utile lors de la manipulation de donn\u00e9es import\u00e9es ou en pr\u00e9paration d’analyses.<\/p>\n

Pr\u00e9sentation de la Syntaxe de la Fonction<\/h2>\n

La syntaxe de la fonction TYPE est concise, n\u00e9cessitant un unique argument :<\/p>\n

=TYPE(valeur)<\/code><\/pre>\n
 Ici, valeur<\/code> d\u00e9signe la r\u00e9f\u00e9rence de la cellule dont vous voulez conna\u00eetre le type. La fonction renvoie des valeurs num\u00e9riques sp\u00e9cifiques selon la nature de la donn\u00e9e :<\/p>\n
    \n
  • 1 pour un nombre<\/li>\n
  • 2 pour du texte<\/li>\n
  • 4 pour une formule<\/li>\n
  • 16 pour une r\u00e9f\u00e9rence de cellule, comme A1 ou H34<\/li>\n
  • 64 pour une matrice<\/li>\n
  • 128 pour un objet d’erreur, comme #VALEUR!<\/li>\n<\/ul>\n
    Exemples d’utilisation de la Fonction<\/h2>\n
     Ci-dessous, quelques illustrations pratiques de l’utilisation de la fonction TYPE :<\/p>\n
    =TYPE(42) - R\u00e9sultat : 1 =TYPE(\"Bonjour\") - R\u00e9sultat : 2 =TYPE(A1+B1) - R\u00e9sultat : 4 si A1 et B1 contiennent des chiffres =TYPE(REF!) - R\u00e9sultat : 128<\/code><\/pre>\n
    Cas Pratiques d’Utilisation<\/h2>\n
     Examinons des scenarios o\u00f9 la fonction TYPE s’av\u00e8re extr\u00eamement utile.<\/p>\n
     Cas pratique 1 : Validation des types de donn\u00e9es durant des importations massives<\/strong><\/p>\n
     Consid\u00e9rez que vous avez import\u00e9 un grand volume de donn\u00e9es dans Excel ou Google Sheets et vous souhaitez v\u00e9rifier que les donn\u00e9es dans certaines colonnes correspondent au type attendu. Utilisez cette fonction pour confirmer, par exemple, qu’une colonne cens\u00e9e contenir uniquement des nombres ne comporte pas de texte par erreur. <\/p>\n
    =SI(TYPE(A2)<>1, \"V\u00e9rifier la donn\u00e9e\", \"Correct\")<\/code><\/pre>\n
     Cette formule \u00e9value si la cellule A2 contient un type autre que nombre. Si tel est le cas, elle retourne un avertissement pour v\u00e9rifier la donn\u00e9e.<\/p>\n
     Cas pratique 2 : S\u00e9paration des types de donn\u00e9es avant une analyse<\/strong><\/p>\n
     Imaginez que vous disposez d’une liste de donn\u00e9es h\u00e9t\u00e9rog\u00e8nes et que vous devez isoler les nombres des textes pour r\u00e9aliser des analyses statistiques sur les nombres uniquement.<\/p>\n
    =SI(TYPE(A2)=1, A2, \"\")<\/code><\/pre>\n
     Cette formule copie la valeur de la cellule A2 si elle contient un nombre ou laisse la cellule vide autrement. Vous pouvez r\u00e9pliquer cette formule sur une colonne enti\u00e8re pour effectuer un filtrage des valeurs num\u00e9riques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un nombRe indiquant le type de donn\u00e9es d\u2019une valeuR<\/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-6824","post","type-post","status-publish","format-standard","hentry","category-informations"],"acf":[],"yoast_head":"\nFonction TYPE dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TYPE 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\/type\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TYPE dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TYPE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/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:15:43+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TYPE 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\/type\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/type\/\",\"name\":\"Fonction TYPE 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:43+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TYPE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/type\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/type\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/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\"}]},{\"@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 TYPE dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TYPE 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\/type\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TYPE dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TYPE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/type\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:43+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TYPE 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\/type\/","url":"https:\/\/functiontranslator.com\/fr\/type\/","name":"Fonction TYPE 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:43+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TYPE d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/type\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/type\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/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"}]},{"@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\/6824","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=6824"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6824\/revisions"}],"predecessor-version":[{"id":29833,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6824\/revisions\/29833"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}