{"id":13950,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/tipo-de-error\/"},"modified":"2021-02-26T08:46:51","modified_gmt":"2021-02-26T08:46:51","slug":"error-type","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/error-type\/","title":{"rendered":"TIPO.DE.ERROR"},"content":{"rendered":"

Introducci\u00f3n a la funci\u00f3n de manejo de errores en hojas de c\u00e1lculo<\/h2>\n

En Microsoft Excel y Google Sheets, la funci\u00f3n TIPO.DE.ERROR (ERROR.TYPE en ingl\u00e9s) es utilizada para identificar el tipo de error en una celda. Devuelve un n\u00famero que corresponde a uno de los varios tipos de errores posibles en Excel y Google Sheets. Resulta especialmente \u00fatil para el manejo de errores mediante pruebas y condiciones dentro de funciones m\u00e1s complejas.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n es bastante simple:<\/p>\n

=TIPO.DE.ERROR(valor)<\/code><\/pre>\n
Donde valor<\/em> es la referencia a la celda cuyo error se desea identificar. A continuaci\u00f3n, detallamos los diferentes tipos de errores y sus correspondientes c\u00f3digos que esta funci\u00f3n puede devolver:<\/p>\n\n\n\n\n\n\n\n\n\n\n
Error<\/th>\nC\u00f3digo<\/th>\n<\/tr>\n
#N\/A (No disponible)<\/td>\n1<\/td>\n<\/tr>\n
#VALOR!<\/td>\n2<\/td>\n<\/tr>\n
#\u00a1REF!<\/td>\n3<\/td>\n<\/tr>\n
#DIV\/0!<\/td>\n4<\/td>\n<\/tr>\n
#\u00a1NUM!<\/td>\n5<\/td>\n<\/tr>\n
#NOMBRE?<\/td>\n6<\/td>\n<\/tr>\n
#\u00a1NULO!<\/td>\n7<\/td>\n<\/tr>\n
#\u00a1DATO!<\/td>\n8<\/td>\n<\/tr>\n<\/table>\n
Por ejemplo, si en la celda A1 tenemos un error #DIV\/0!, la f\u00f3rmula ser\u00eda:<\/p>\n
=TIPO.DE.ERROR(A1)<\/code><\/pre>\n
Y el resultado que devolver\u00eda ser\u00eda 4<\/strong>, correspondiente al error #DIV\/0!.<\/p>\n
Aplicaciones pr\u00e1cticas<\/h2>\n
A continuaci\u00f3n se describen dos escenarios en los que la funci\u00f3n TIPO.DE.ERROR es particularmente \u00fatil.<\/p>\n
Detecci\u00f3n y manejo de errores en reportes<\/h2>\n
Imagina que est\u00e1s preparando un reporte financiero y algunas f\u00f3rmulas dependen de celdas con datos que pueden no estar disponibles, lo que podr\u00eda resultar en errores #N\/A. Para evitar la propagaci\u00f3n de estos errores, puedes verificar y manejar estos casos espec\u00edficos.<\/p>\n
=SI(TIPO.DE.ERROR(B2)=1, \"Dato no disponible\", B2)<\/code><\/pre>\n
En este caso, si B2 contiene un error #N\/A, la f\u00f3rmula mostrar\u00e1 \u00abDato no disponible\u00bb, y si no hay error, mostrar\u00e1 el contenido de B2.<\/p>\n
Validaci\u00f3n de datos antes de realizar c\u00e1lculos<\/h2>\n
Supongamos que tienes un conjunto de datos donde se realizan varios c\u00e1lculos. Antes de proceder, es prudente verificar si alguno de los valores de entrada contiene errores para evitar resultados err\u00f3neos.<\/p>\n
=SI(TIPO.DE.ERROR(C5)=0, C5*C10, \"Error en la entrada\")<\/code><\/pre>\n
Este ejemplo multiplica C5 por C10 solo si C5 no contiene errores. Si C5 tiene alg\u00fan error, devolver\u00e1 \u00abError en la entrada\u00bb. Esto asegura que solo se realizan c\u00e1lculos con datos v\u00e1lidos.<\/p>\n
Conociendo y aplicando correctamente la funci\u00f3n TIPO.DE.ERROR, puedes mejorar significativamente el manejo de errores en tus hojas de c\u00e1lculo, haciendo tus datos m\u00e1s robustos y tus an\u00e1lisis m\u00e1s confiables.<\/p>\n","protected":false},"excerpt":{"rendered":"
Devuelve un n\u00famero que corresponde a un tipo de error<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[544],"tags":[],"class_list":["post-13950","post","type-post","status-publish","format-standard","hentry","category-informacion"],"acf":[],"yoast_head":"\nFunci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\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\/es\/error-type\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/error-type\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:46:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/error-type\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/error-type\/\",\"name\":\"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:46:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/error-type\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/error-type\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/error-type\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Informaci\u00f3n\",\"item\":\"https:\/\/functiontranslator.com\/es\/informacion\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TIPO.DE.ERROR\"}]},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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\/es\/error-type\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/error-type\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:46:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/error-type\/","url":"https:\/\/functiontranslator.com\/es\/error-type\/","name":"Funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:46:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ERROR.TYPE (TIPO.DE.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/error-type\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/error-type\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/error-type\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Informaci\u00f3n","item":"https:\/\/functiontranslator.com\/es\/informacion\/"},{"@type":"ListItem","position":3,"name":"TIPO.DE.ERROR"}]},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13950","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13950"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13950\/revisions"}],"predecessor-version":[{"id":30012,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13950\/revisions\/30012"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}