{"id":6739,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/alea-entre-bornes\/"},"modified":"2021-02-26T08:12:45","modified_gmt":"2021-02-26T08:12:45","slug":"randbetween","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/randbetween\/","title":{"rendered":"ALEA.ENTRE.BORNES"},"content":{"rendered":"

La fonction RANDBETWEEN<\/strong>, appel\u00e9e ALEA.ENTRE.BORNES<\/strong> en fran\u00e7ais dans Excel, est essentielle pour g\u00e9n\u00e9rer des nombres entiers al\u00e9atoires dans un intervalle sp\u00e9cifi\u00e9. Elle se r\u00e9v\u00e8le extr\u00eamement utile pour simuler des donn\u00e9es, r\u00e9aliser des tirages au sort, ou dans tout contexte n\u00e9cessitant une s\u00e9lection al\u00e9atoire.<\/p>\n

Description de la fonction<\/h2>\n

Cette fonction g\u00e9n\u00e8re un nombre entier al\u00e9atoire entre une limite inf\u00e9rieure et une limite sup\u00e9rieure sp\u00e9cifi\u00e9es par l’utilisateur. Le r\u00e9sultat est dynamique : le nombre g\u00e9n\u00e9r\u00e9 peut varier \u00e0 chaque recalcul de la feuille ou \u00e0 chaque ouverture du fichier.<\/p>\n

Syntaxe<\/h2>\n
=RANDBETWEEN(bas, haut)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • bas<\/strong> : le plus petit nombre entier que la fonction peut g\u00e9n\u00e9rer.<\/li>\n
  • haut<\/strong> : le plus grand nombre entier que la fonction peut g\u00e9n\u00e9rer.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
     =RANDBETWEEN(1, 10)<\/code> - G\u00e9n\u00e8re un nombre entier al\u00e9atoire entre 1 et 10. =RANDBETWEEN(100, 200)<\/code> - G\u00e9n\u00e8re un nombre entier al\u00e9atoire entre 100 et 200. <\/pre>\n
    Applications pratiques<\/h2>\n
      \n
    • \n
      Cr\u00e9ation d’un tirage au sort<\/h2>\n
      Pour tirer au sort 5 gagnants parmi 50 participants num\u00e9rot\u00e9s de 1 \u00e0 50, utilisez la formule :<\/p>\n
      =RANDBETWEEN(1, 50)<\/code><\/pre>\n
      Reproduisez cette formule dans cinq cellules distinctes. Chaque cellule affichera un num\u00e9ro de participant s\u00e9lectionn\u00e9 al\u00e9atoirement. Cependant, cette m\u00e9thode peut g\u00e9n\u00e9rer des doublons. Pour un tirage sans doublon, envisagez d’autres solutions, comme des scripts ou des add-ons.<\/p>\n<\/li>\n
    • \n
      Simulation de donn\u00e9es pour une analyse<\/h2>\n
      Un analyste peut avoir besoin de simuler un jeu de donn\u00e9es, comme un ensemble de 100 salaires al\u00e9atoires variant de 25 000 \u20ac \u00e0 50 000 \u20ac, pour tester des algorithmes ou mod\u00e8les. Utilisez la formule suivante pour cr\u00e9er votre jeu de donn\u00e9es :<\/p>\n
      =RANDBETWEEN(25000, 50000)<\/code><\/pre>\n
      En copiant cette formule dans 100 cellules, vous obtiendrez rapidement un ensemble de donn\u00e9es simul\u00e9 pr\u00eat pour l’analyse.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      Renvoie un nombRe al\u00e9atoiRe entRe les nombRes que vous sp\u00e9cifiez<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6739","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction RANDBETWEEN (ALEA.ENTRE.BORNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/randbetween\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction RANDBETWEEN (ALEA.ENTRE.BORNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/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:12:45+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/randbetween\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/randbetween\/\",\"name\":\"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:12:45+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction RANDBETWEEN (ALEA.ENTRE.BORNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/randbetween\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/randbetween\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/randbetween\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"ALEA.ENTRE.BORNES\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction RANDBETWEEN (ALEA.ENTRE.BORNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/randbetween\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction RANDBETWEEN (ALEA.ENTRE.BORNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/randbetween\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:12:45+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/randbetween\/","url":"https:\/\/functiontranslator.com\/fr\/randbetween\/","name":"Fonction RANDBETWEEN (ALEA.ENTRE.BORNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:12:45+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction RANDBETWEEN (ALEA.ENTRE.BORNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/randbetween\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/randbetween\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/randbetween\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"ALEA.ENTRE.BORNES"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6739"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6739\/revisions"}],"predecessor-version":[{"id":29750,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6739\/revisions\/29750"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}