{"id":14164,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/randbetween\/"},"modified":"2021-02-26T08:56:46","modified_gmt":"2021-02-26T08:56:46","slug":"randbetween","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/randbetween\/","title":{"rendered":"RANDBETWEEN"},"content":{"rendered":"

La funci\u00f3n RANDBETWEEN es sumamente \u00fatil en Microsoft Excel y Google Sheets, pues permite generar un n\u00famero entero aleatorio dentro de un rango especificado por el usuario. En esta gu\u00eda, explicaremos c\u00f3mo utilizar RANDBETWEEN a trav\u00e9s de ejemplos pr\u00e1cticos y exploraremos sus aplicaciones en diversos c\u00e1lculos y an\u00e1lisis.<\/p>\n

Sintaxis y ejemplos b\u00e1sicos<\/h2>\n

La estructura de la funci\u00f3n RANDBETWEEN es simple y se utiliza de la siguiente manera:<\/p>\n

=RANDBETWEEN(inferior, superior)<\/code><\/pre>\n
    \n
  • inferior:<\/strong> El l\u00edmite inferior del rango de n\u00fameros, que debe ser un entero.<\/li>\n
  • superior:<\/strong> El l\u00edmite superior del rango de n\u00fameros, tambi\u00e9n un entero.<\/li>\n<\/ul>\n
    Es importante destacar que los n\u00fameros generados incluyen tanto el l\u00edmite inferior como el superior.<\/p>\n
    A continuaci\u00f3n, se presentan algunos ejemplos de uso de esta funci\u00f3n:<\/p>\n
      \n
    • Para generar un n\u00famero aleatorio entre 1 y 10, emplear\u00edas la f\u00f3rmula: =RANDBETWEEN(1, 10)<\/code>.<\/li>\n
    • Para un n\u00famero aleatorio entre -5 y 5, la f\u00f3rmula ser\u00eda: =RANDBETWEEN(-5, 5)<\/code>.<\/li>\n<\/ul>\n
      Aplicaciones pr\u00e1cticas<\/h2>\n
      RANDBETWEEN es extremadamente \u00fatil en una amplia gama de escenarios pr\u00e1cticos. A continuaci\u00f3n, se describen dos ejemplos espec\u00edficos:<\/p>\n
      Situaci\u00f3n 1: Simulaci\u00f3n de datos para un sorteo<\/h2>\n
      Imagina que est\u00e1s organizando un sorteo en el cual cada participante tiene asignado un n\u00famero del 1 al 100. Para seleccionar un ganador de forma aleatoria, podr\u00edas emplear RANDBETWEEN de la manera siguiente:<\/p>\n
      =RANDBETWEEN(1, 100)<\/code><\/pre>\n
      Cada vez que recalculas la hoja, se generar\u00e1 un n\u00famero diferente, correspondiente al n\u00famero de un participante, identificando as\u00ed al ganador.<\/p>\n
      Situaci\u00f3n 2: Creaci\u00f3n de datos ficticios para an\u00e1lisis<\/h2>\n
      En el \u00e1mbito del an\u00e1lisis de datos, en particular en la ense\u00f1anza o el aprendizaje de nuevas t\u00e9cnicas, frecuentemente se necesitan conjuntos de datos. Utilizar RANDBETWEEN para generar puntos de datos aleatorios puede ser muy eficaz. Por ejemplo, si necesitas una lista de 50 edades aleatorias entre 20 y 70 a\u00f1os, podr\u00edas aplicar la siguiente f\u00f3rmula en Excel o Google Sheets:<\/p>\n
      =RANDBETWEEN(20, 70)<\/code><\/pre>\n
      Simplemente arrastra la esquina inferior derecha de la celda hacia abajo para copiar la f\u00f3rmula a las dem\u00e1s celdas y generar un completo conjunto de datos.<\/p>\n
      En resumen, RANDBETWEEN no s\u00f3lo es una funci\u00f3n de f\u00e1cil uso, sino que tambi\u00e9n es vers\u00e1til en cuanto a sus aplicaciones, convirti\u00e9ndola en una herramienta indispensable tanto para el an\u00e1lisis de datos como para diversas tareas en Excel y Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Devuelve un n\u00famero aleatorio entre los n\u00fameros que especifique<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[535],"tags":[],"class_list":["post-14164","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n RANDBETWEEN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n RANDBETWEEN 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\/randbetween\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n RANDBETWEEN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n RANDBETWEEN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/randbetween\/\" \/>\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:56:46+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 RANDBETWEEN 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\/randbetween\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/randbetween\/\",\"name\":\"Funci\u00f3n RANDBETWEEN 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:56:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n RANDBETWEEN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/randbetween\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/randbetween\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/randbetween\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1ticas y trigonometr\u00eda\",\"item\":\"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"RANDBETWEEN\"}]},{\"@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 RANDBETWEEN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n RANDBETWEEN 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\/randbetween\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n RANDBETWEEN en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n RANDBETWEEN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/randbetween\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:56:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n RANDBETWEEN 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\/randbetween\/","url":"https:\/\/functiontranslator.com\/es\/randbetween\/","name":"Funci\u00f3n RANDBETWEEN 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:56:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n RANDBETWEEN de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/randbetween\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/randbetween\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/randbetween\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1ticas y trigonometr\u00eda","item":"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/"},{"@type":"ListItem","position":3,"name":"RANDBETWEEN"}]},{"@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\/14164","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=14164"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14164\/revisions"}],"predecessor-version":[{"id":30255,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14164\/revisions\/30255"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}