{"id":11086,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/aleatorioentre\/"},"modified":"2021-02-25T17:27:50","modified_gmt":"2021-02-25T17:27:50","slug":"randbetween","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/","title":{"rendered":"ALEAT\u00d3RIOENTRE"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o de Gera\u00e7\u00e3o de N\u00fameros Aleat\u00f3rios<\/h2>\n

A fun\u00e7\u00e3o RANDBETWEEN, conhecida em portugu\u00eas como ALEAT\u00d3RIOENTRE, \u00e9 uma f\u00f3rmula amplamente utilizada tanto no Microsoft Excel quanto no Google Planilhas para gerar um n\u00famero inteiro aleat\u00f3rio dentro de um intervalo especificado. Essa fun\u00e7\u00e3o \u00e9 particularmente \u00fatil em v\u00e1rias situa\u00e7\u00f5es, incluindo simula\u00e7\u00f5es, an\u00e1lises estat\u00edsticas, jogos, sorteios, e qualquer cen\u00e1rio que exija um elemento de aleatoriedade.<\/p>\n

Sintaxe da Fun\u00e7\u00e3o<\/h2>\n

A fun\u00e7\u00e3o RANDBETWEEN tem a seguinte sintaxe:<\/p>\n

  =RANDBETWEEN(inferior, superior) <\/code> <\/pre>\n
Onde: <\/p>\n
    \n
  • inferior<\/strong>: O menor n\u00famero que voc\u00ea deseja gerar.<\/li>\n
  • superior<\/strong>: O maior n\u00famero que voc\u00ea deseja gerar.<\/li>\n<\/ul>\n
    Por exemplo, =RANDBETWEEN(1, 10)<\/code> ir\u00e1 gerar um n\u00famero aleat\u00f3rio entre 1 e 10.<\/p>\n
    Exemplo Pr\u00e1tico 1: Simula\u00e7\u00e3o de Sorteio<\/h2>\n
    Imagine que voc\u00ea deseja realizar um sorteio entre 100 participantes, numerados de 1 a 100. A fun\u00e7\u00e3o ALEAT\u00d3RIOENTRE pode ser usada para determinar o n\u00famero do participante vencedor de forma imparcial.<\/p>\n
      =RANDBETWEEN(1, 100) <\/code> <\/pre>\n
    A cada rec\u00e1lculo da planilha ou reativa\u00e7\u00e3o da fun\u00e7\u00e3o, um novo n\u00famero ser\u00e1 gerado, indicando um novo vencedor.<\/p>\n
    Exemplo Pr\u00e1tico 2: Decis\u00f5es Aleat\u00f3rias para Jogos de Mesa<\/h2>\n
    Suponha que voc\u00ea est\u00e1 jogando um jogo de tabuleiro e necessita de uma decis\u00e3o baseada na sele\u00e7\u00e3o aleat\u00f3ria de op\u00e7\u00f5es numeradas de 1 a 6, semelhante ao lan\u00e7amento de dados. Utilizar a fun\u00e7\u00e3o ALEAT\u00d3RIOENTRE simula esse processo de forma eficaz.<\/p>\n
      =RANDBETWEEN(1, 6) <\/code> <\/pre>\n
    Isso ajuda a assegurar que o jogo seja justo e que todas as jogadas sejam determinadas pelo acaso.<\/p>\n
    Considera\u00e7\u00f5es Adicionais<\/h2>\n
    \u00c9 importante notar que os n\u00fameros gerados s\u00e3o verdadeiramente aleat\u00f3rios e, como tal, podem eventualmente se repetir. Se for necess\u00e1rio obter uma sequ\u00eancia de n\u00fameros aleat\u00f3rios sem repeti\u00e7\u00f5es, voc\u00ea precisar\u00e1 implementar uma l\u00f3gica adicional para verificar e remover duplicatas.<\/p>\n
    Lembre-se de que fun\u00e7\u00f5es que geram n\u00fameros aleat\u00f3rios recalculam a cada modifica\u00e7\u00e3o na planilha, resultando em mudan\u00e7as frequentes nos n\u00fameros. Para prevenir altera\u00e7\u00f5es inadvertidas, uma pr\u00e1tica recomendada \u00e9 copiar e colar esses n\u00fameros como valores est\u00e1ticos logo ap\u00f3s sua gera\u00e7\u00e3o.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devolve um n\u00famero aleat\u00f3rio entre os n\u00fameros especificados<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[437],"tags":[],"class_list":["post-11086","post","type-post","status-publish","format-standard","hentry","category-matematica-e-trigonometria"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/randbetween\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:27:50+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\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\/pt-pt\/randbetween\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/\",\"name\":\"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:27:50+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1tica e trigonometria\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ALEAT\u00d3RIOENTRE\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos 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\/pt-pt\/randbetween\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:27:50+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/","url":"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/","name":"Fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:27:50+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o RANDBETWEEN (ALEAT\u00d3RIOENTRE) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/randbetween\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/randbetween\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1tica e trigonometria","item":"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/"},{"@type":"ListItem","position":3,"name":"ALEAT\u00d3RIOENTRE"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11086"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11086\/revisions"}],"predecessor-version":[{"id":25915,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11086\/revisions\/25915"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}