{"id":13864,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/elegir\/"},"modified":"2021-02-26T08:43:35","modified_gmt":"2021-02-26T08:43:35","slug":"choose","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/choose\/","title":{"rendered":"ELEGIR"},"content":{"rendered":"

Descripci\u00f3n y Sintaxis de la Funci\u00f3n ELEGIR<\/h2>\n

La funci\u00f3n ELEGIR en Microsoft Excel y Google Sheets es una herramienta que permite seleccionar un valor de un conjunto de datos bas\u00e1ndose en un \u00edndice num\u00e9rico. Esta funci\u00f3n es especialmente \u00fatil para extraer valores espec\u00edficos de una lista seg\u00fan un criterio determinado.<\/p>\n

Sintaxis b\u00e1sica:<\/p>\n

=ELEGIR(indice_num, valor1, valor2, ...)<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • indice_num<\/strong>: Es un n\u00famero que indica el valor que debe ser retornado por la funci\u00f3n. Este debe ser un n\u00famero entero entre 1 y la cantidad total de valores disponibles.<\/li>\n
  • valor1, valor2, …<\/strong>: Son los valores entre los cuales la funci\u00f3n seleccionar\u00e1. La funci\u00f3n puede manejar hasta 254 valores en Excel y hasta 30 valores en Google Sheets.<\/li>\n<\/ul>\n
    Ejemplos Pr\u00e1cticos de Aplicaci\u00f3n<\/h2>\n
    Exploraremos algunos ejemplos para entender mejor el uso de la funci\u00f3n ELEGIR.<\/p>\n
    Escenario 1: Decisi\u00f3n seg\u00fan el d\u00eda de la semana<\/h2>\n
    Imagina que necesitas realizar actividades distintas seg\u00fan el d\u00eda de la semana.<\/p>\n
    Ejemplo para Excel\/Google Sheets:<\/p>\n
    =ELEGIR(DIA.SEMANA(HOY()), \"Domingo\", \"Lunes\", \"Martes\", \"Mi\u00e9rcoles\", \"Jueves\", \"Viernes\", \"S\u00e1bado\")<\/code><\/pre>\n
    Explicaci\u00f3n:<\/p>\n
      \n
    • La funci\u00f3n DIA.SEMANA(HOY())<\/code> devuelve un n\u00famero del 1 al 7, correspondiente a cada d\u00eda de la semana.<\/li>\n
    • La funci\u00f3n ELEGIR toma ese n\u00famero para seleccionar la actividad correspondiente al d\u00eda actual.<\/li>\n<\/ul>\n
      Por ejemplo, si hoy es lunes, la funci\u00f3n DIA.SEMANA(HOY())<\/code> retornar\u00eda 2, y la funci\u00f3n ELEGIR devolver\u00eda \u00abLunes\u00bb.<\/p>\n
      Escenario 2: Selecci\u00f3n de par\u00e1metros en un modelo<\/h2>\n
      Si est\u00e1s trabajando en un modelo matem\u00e1tico o financiero en el que algunos par\u00e1metros var\u00edan seg\u00fan una entrada num\u00e9rica, la funci\u00f3n ELEGIR puede facilitar significativamente la selecci\u00f3n de estos par\u00e1metros.<\/p>\n
      Ejemplo:<\/p>\n
      =ELEGIR(A1, 100, 200, 300, 400)<\/code><\/pre>\n
      Donde:<\/p>\n
        \n
      • A1<\/strong> es la celda que contiene el \u00edndice.<\/li>\n
      • 100, 200, 300, 400<\/strong> son los par\u00e1metros que pueden ser elegidos.<\/li>\n<\/ul>\n
        Si A1 tiene el valor 3, la funci\u00f3n devolver\u00e1 300, valor que puede ser utilizado directamente en c\u00e1lculos subsecuentes del modelo.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Elige un valor de una lista de valores<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[537],"tags":[],"class_list":["post-13864","post","type-post","status-publish","format-standard","hentry","category-busqueda-y-referencia"],"acf":[],"yoast_head":"\nFunci\u00f3n CHOOSE (ELEGIR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CHOOSE (ELEGIR) 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\/choose\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n CHOOSE (ELEGIR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n CHOOSE (ELEGIR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/choose\/\" \/>\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:43:35+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 CHOOSE (ELEGIR) 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\/choose\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/choose\/\",\"name\":\"Funci\u00f3n CHOOSE (ELEGIR) 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:43:35+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n CHOOSE (ELEGIR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/choose\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/choose\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/choose\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"B\u00fasqueda y referencia\",\"item\":\"https:\/\/functiontranslator.com\/es\/busqueda-y-referencia\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ELEGIR\"}]},{\"@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 CHOOSE (ELEGIR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n CHOOSE (ELEGIR) 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\/choose\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n CHOOSE (ELEGIR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n CHOOSE (ELEGIR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/choose\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:43:35+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n CHOOSE (ELEGIR) 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\/choose\/","url":"https:\/\/functiontranslator.com\/es\/choose\/","name":"Funci\u00f3n CHOOSE (ELEGIR) 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:43:35+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n CHOOSE (ELEGIR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/choose\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/choose\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/choose\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"B\u00fasqueda y referencia","item":"https:\/\/functiontranslator.com\/es\/busqueda-y-referencia\/"},{"@type":"ListItem","position":3,"name":"ELEGIR"}]},{"@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\/13864","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=13864"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13864\/revisions"}],"predecessor-version":[{"id":29927,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13864\/revisions\/29927"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}