{"id":14010,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/si-error\/"},"modified":"2021-02-26T08:50:01","modified_gmt":"2021-02-26T08:50:01","slug":"iferror","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/iferror\/","title":{"rendered":"SI.ERROR"},"content":{"rendered":"

Descripci\u00f3n y Sintaxis de la Funci\u00f3n en MS Excel y Google Sheets<\/h2>\n

La funci\u00f3n SI.ERROR en Excel y Google Sheets se utiliza para controlar los errores en las f\u00f3rmulas, devolviendo un valor alternativo especificado por el usuario cuando la f\u00f3rmula original produce un error. Esta funci\u00f3n es fundamental para mantener la integridad de los datos y para asegurar que las hojas de c\u00e1lculo sean claras y f\u00e1ciles de interpretar.<\/p>\n

Sintaxis:<\/p>\n

=SI.ERROR(valor, valor_si_error)<\/code><\/pre>\n
    \n
  • valor<\/code>: La f\u00f3rmula o expresi\u00f3n que se eval\u00faa. Si esta conduce a un error, la funci\u00f3n devolver\u00e1 el valor especificado en valor_si_error<\/code>.<\/li>\n
  • valor_si_error<\/code>: El valor que se retorna si valor<\/code> resulta en un error. Este argumento puede ser un n\u00famero, texto, otra f\u00f3rmula o incluso otra funci\u00f3n.<\/li>\n<\/ul>\n
    Ejemplo:<\/p>\n
    =SI.ERROR(1\/0, \"Error en divisi\u00f3n\")<\/code><\/pre>\n
    Este ejemplo intenta dividir 1 entre 0, lo cual es imposible y resulta en un error de divisi\u00f3n. Aqu\u00ed, SI.ERROR<\/code> retorna \u00abError en divisi\u00f3n\u00bb.<\/p>\n
    Casos pr\u00e1cticos de aplicaci\u00f3n<\/h2>\n
    1. Manejo de errores en c\u00e1lculo de promedios<\/h3>\n
    Supongamos que tienes un conjunto de datos con las puntuaciones de estudiantes y deseas calcular el promedio, pero algunos valores son errores o est\u00e1n vac\u00edos porque algunos estudiantes no participaron en la prueba.<\/p>\n
    Soluci\u00f3n:<\/p>\n
    =SI.ERROR(PROMEDIO(A2:A10), \"Datos insuficientes\")<\/code><\/pre>\n
    Explicaci\u00f3n:<\/p>\n
    La f\u00f3rmula anterior calcula el promedio de los valores en el rango de A2 a A10. Si este conjunto contiene errores o divisiones por cero, lo que provocar\u00eda que PROMEDIO devuelva un error, SI.ERROR<\/code> interviene y devuelve \u00abDatos insuficientes\u00bb. Esto mejora la presentaci\u00f3n evitando mostrar un error cr\u00edptico que podr\u00eda confundir al usuario.<\/p>\n
    2. Evitando errores en b\u00fasqueda de datos<\/h3>\n
    Si est\u00e1s extrayendo datos de una celda bas\u00e1ndote en un \u00edndice y este no es v\u00e1lido, normalmente se producir\u00eda un error #\u00a1REF!<\/code>.<\/p>\n
    Soluci\u00f3n:<\/p>\n
    =SI.ERROR(INDICE(B2:B10, MATCH(\"Objetivo\", A2:A10, 0)), \"Objetivo no encontrado\")<\/code><\/pre>\n
    Explicaci\u00f3n:<\/p>\n
    Esta f\u00f3rmula busca la palabra \u00abObjetivo\u00bb en el rango A2:A10. La funci\u00f3n MATCH<\/code> devuelve la posici\u00f3n de \u00abObjetivo\u00bb en dicho rango. Si \u00abObjetivo\u00bb no est\u00e1 presente, MATCH<\/code> genera un error, y INDICE<\/code> tambi\u00e9n fallar\u00eda. SI.ERROR<\/code> previene que estos errores se muestren y, en su lugar, devuelve \u00abObjetivo no encontrado\u00bb. Este m\u00e9todo aporta claridad y simplifica la gesti\u00f3n de errores al trabajar con grandes vol\u00famenes de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve un valor que se especifica si una f\u00f3rmula lo eval\u00faa como un error; de lo contrario, devuelve el resultado de la f\u00f3rmula<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[538],"tags":[],"class_list":["post-14010","post","type-post","status-publish","format-standard","hentry","category-logica-2"],"acf":[],"yoast_head":"\nFunci\u00f3n IFERROR (SI.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IFERROR (SI.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\/iferror\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n IFERROR (SI.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n IFERROR (SI.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/iferror\/\" \/>\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:50:01+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 IFERROR (SI.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\/iferror\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/iferror\/\",\"name\":\"Funci\u00f3n IFERROR (SI.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:50:01+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n IFERROR (SI.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/iferror\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/iferror\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/iferror\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"L\u00f3gica\",\"item\":\"https:\/\/functiontranslator.com\/es\/logica-2\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SI.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 IFERROR (SI.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n IFERROR (SI.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\/iferror\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n IFERROR (SI.ERROR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n IFERROR (SI.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/iferror\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:50:01+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n IFERROR (SI.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\/iferror\/","url":"https:\/\/functiontranslator.com\/es\/iferror\/","name":"Funci\u00f3n IFERROR (SI.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:50:01+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n IFERROR (SI.ERROR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/iferror\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/iferror\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/iferror\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"L\u00f3gica","item":"https:\/\/functiontranslator.com\/es\/logica-2\/"},{"@type":"ListItem","position":3,"name":"SI.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\/14010","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=14010"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14010\/revisions"}],"predecessor-version":[{"id":30067,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14010\/revisions\/30067"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}