{"id":14055,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/es-impar\/"},"modified":"2021-02-26T08:52:47","modified_gmt":"2021-02-26T08:52:47","slug":"isodd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/isodd\/","title":{"rendered":"ES.IMPAR"},"content":{"rendered":"

Introducci\u00f3n a la funci\u00f3n ISODD (ES.IMPAR)<\/h2>\n

La funci\u00f3n ISODD, o ES.IMPAR en su versi\u00f3n en espa\u00f1ol, es ampliamente utilizada en Microsoft Excel y Google Sheets para determinar si un n\u00famero es impar. Esta funci\u00f3n resulta especialmente \u00fatil en diversos an\u00e1lisis de datos donde la paridad del n\u00famero es crucial para la toma de decisiones o para realizar filtrados espec\u00edficos.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n ES.IMPAR es bastante sencilla:<\/p>\n

=ES.IMPAR(n\u00famero)<\/code><\/pre>\n
En esta f\u00f3rmula, n\u00famero<\/code> se refiere al valor que se desea evaluar. Si el n\u00famero es impar, la funci\u00f3n devolver\u00e1 TRUE (VERDADERO), y si es par, devolver\u00e1 FALSE (FALSO).<\/p>\n
Ejemplo 1:<\/strong><\/p>\n
=ES.IMPAR(3)<\/code><\/pre>\n
Resultado: TRUE<\/p>\n
Ejemplo 2:<\/strong><\/p>\n
=ES.IMPAR(2)<\/code><\/pre>\n
Resultado: FALSE<\/p>\n
Aplicaciones pr\u00e1cticas<\/h2>\n
La funci\u00f3n ES.IMPAR puede ser aplicada en una variedad de contextos anal\u00edticos y pr\u00e1cticos. A continuaci\u00f3n, se describen dos aplicaciones comunes con ejemplos detallados.<\/p>\n
Caso de uso 1: Filtrado de datos<\/h2>\n
Considera que tienes una lista de n\u00fameros y necesitas distinguir los que son impares para realizar ciertas operaciones espec\u00edficas solo con esos valores.<\/p>\n
    \n
  • Lista de n\u00fameros: 10, 21, 22, 35, 48, 59<\/li>\n<\/ul>\n
    Mediante el uso de ES.IMPAR en Excel o Google Sheets, puedes configurar una columna auxiliar para marcar los n\u00fameros impares:<\/p>\n\n\n\n\n\n\n\n\n
    N\u00famero<\/th>\n\u00bfEs impar?<\/th>\n<\/tr>\n
    10<\/td>\n=ES.IMPAR(10)<\/td>\n<\/tr>\n
    21<\/td>\n=ES.IMPAR(21)<\/td>\n<\/tr>\n
    22<\/td>\n=ES.IMPAR(22)<\/td>\n<\/tr>\n
    35<\/td>\n=ES.IMPAR(35)<\/td>\n<\/tr>\n
    48<\/td>\n=ES.IMPAR(48)<\/td>\n<\/tr>\n
    59<\/td>\n=ES.IMPAR(59)<\/td>\n<\/tr>\n<\/table>\n
    De esta forma, puedes identificar de manera r\u00e1pida y eficiente los n\u00fameros impares (21, 35, 59) para procesarlos seg\u00fan se requiera.<\/p>\n
    Caso de uso 2: An\u00e1lisis estad\u00edstico<\/h2>\n
    En an\u00e1lisis de datos, es com\u00fan querer segmentar un gran conjunto de datos en grupos basados en criterios num\u00e9ricos, como la paridad de los n\u00fameros, para examinar tendencias o comportamientos particulares.<\/p>\n
    Por ejemplo, si dispones de un conjunto de datos con las fechas de transacciones realizadas en un mes, podr\u00edas segmentarlos as\u00ed:<\/p>\n
      \n
    • Fechas de transacci\u00f3n: 1, 2, 3, 4, 5, 6, …, 30<\/li>\n<\/ul>\n
      Puedes utilizar la funci\u00f3n ES.IMPAR para observar c\u00f3mo var\u00edan las actividades de compra entre los d\u00edas impares y pares del mes:<\/p>\n
      Columna A | Columna B D\u00eda | \u00bfEs impar? 1 | =ES.IMPAR(A2) 2 | =ES.IMPAR(A3) 3 | =ES.IMPAR(A4) ... 30 | =ES.IMPAR(A31) <\/code><\/pre>\n
      Este an\u00e1lisis inicial puede ayudarte a comprender mejor las diferencias en los patrones de compra y a tomar decisiones informadas basadas en esos insights.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve VERDADERO si el n\u00famero es impar<\/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-14055","post","type-post","status-publish","format-standard","hentry","category-informacion"],"acf":[],"yoast_head":"\nFunci\u00f3n ISODD (ES.IMPAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ISODD (ES.IMPAR) 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\/isodd\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n ISODD (ES.IMPAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n ISODD (ES.IMPAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/isodd\/\" \/>\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:52:47+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 ISODD (ES.IMPAR) 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\/isodd\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/isodd\/\",\"name\":\"Funci\u00f3n ISODD (ES.IMPAR) 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:52:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n ISODD (ES.IMPAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/isodd\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/isodd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/isodd\/#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\":\"ES.IMPAR\"}]},{\"@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 ISODD (ES.IMPAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n ISODD (ES.IMPAR) 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\/isodd\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n ISODD (ES.IMPAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n ISODD (ES.IMPAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/isodd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:52:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n ISODD (ES.IMPAR) 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\/isodd\/","url":"https:\/\/functiontranslator.com\/es\/isodd\/","name":"Funci\u00f3n ISODD (ES.IMPAR) 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:52:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n ISODD (ES.IMPAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/isodd\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/isodd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/isodd\/#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":"ES.IMPAR"}]},{"@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\/14055","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=14055"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14055\/revisions"}],"predecessor-version":[{"id":30150,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14055\/revisions\/30150"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}