{"id":1175,"date":"2018-07-01T15:13:15","date_gmt":"2018-07-01T15:13:15","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1175"},"modified":"2023-11-03T11:09:11","modified_gmt":"2023-11-03T11:09:11","slug":"randbetween","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/","title":{"rendered":"RANDBETWEEN function"},"content":{"rendered":"\n

Excel RANDBETWEEN function generates a random integer between two specified numbers. It’s a useful tool when you need to create random data for testing, simulations, or games. This simple guide explains how to use the RANDBETWEEN function, making it accessible even to high school students.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

RANDBETWEEN(bottom, top)<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
bottom<\/strong><\/td>The lowest integer value you want as the result.<\/td><\/tr>
top<\/strong><\/td>The highest integer value you want as the result.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to Use<\/h2>\n\n\n\n

The RANDBETWEEN function is simple to use. You need to specify the lower and upper limits for the random integer you want to generate. Here’s a step-by-step guide with examples:<\/p>\n\n\n\n

1. Start with an empty cell where you want the random number to appear.<\/p>\n\n\n\n

2. Enter the formula:<\/p>\n\n\n\n

=RANDBETWEEN(bottom, top)<\/code><\/pre>\n\n\n\n
3. Replace “bottom” with the lowest integer you want and “top” with the highest integer you want.<\/p>\n\n\n\n
4. Press Enter, and Excel will generate a random integer between your specified range.<\/p>\n\n\n\n
For example, if you want a random number between 1 and 100, your formula will look like this:<\/p>\n\n\n\n
=RANDBETWEEN(1, 100)<\/code><\/pre>\n\n\n\n
Every time you recalculate your worksheet, the RANDBETWEEN function will provide a new random number within the given range. You can use this feature for various purposes, such as generating random test data, simulating dice rolls, or creating randomized game elements.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
Here are a few practical examples of how to use the RANDBETWEEN function:<\/p>\n\n\n\n
1. Simulating a Dice Roll (1 to 6):<\/p>\n\n\n\n
=RANDBETWEEN(1, 6)<\/code><\/pre>\n\n\n\n
2. Generating a Random Percentage (0% to 100%):<\/p>\n\n\n\n
=RANDBETWEEN(0, 100)<\/code><\/pre>\n\n\n\n
3. Creating Random IDs (1000 to 9999):<\/p>\n\n\n\n
=RANDBETWEEN(1000, 9999)<\/code><\/pre>\n\n\n\n
Additional Information<\/h2>\n\n\n\n
The RANDBETWEEN function is a great tool for generating random numbers within specified ranges. Remember that the generated numbers will change every time your worksheet recalculates. If you want to keep a specific random value, you can copy and paste it as a static value or use Excel’s “Paste Values” feature.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel RANDBETWEEN function generates a random integer between two specified numbers. It’s a useful tool when you need to create random data for…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nRANDBETWEEN function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RANDBETWEEN function\" \/>\n<meta property=\"og:description\" content=\"Excel RANDBETWEEN function generates a random integer between two specified numbers. It’s a useful tool when you need to create random data for...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-01T15:13:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T11:09:11+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"RANDBETWEEN function\",\"datePublished\":\"2018-07-01T15:13:15+00:00\",\"dateModified\":\"2023-11-03T11:09:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\"},\"wordCount\":291,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\",\"name\":\"RANDBETWEEN function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-01T15:13:15+00:00\",\"dateModified\":\"2023-11-03T11:09:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/randbetween\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RANDBETWEEN function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"RANDBETWEEN function","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:\/\/officetuts.net\/excel\/functions\/randbetween\/","og_locale":"en_US","og_type":"article","og_title":"RANDBETWEEN function","og_description":"Excel RANDBETWEEN function generates a random integer between two specified numbers. It’s a useful tool when you need to create random data for...","og_url":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/","article_published_time":"2018-07-01T15:13:15+00:00","article_modified_time":"2023-11-03T11:09:11+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"RANDBETWEEN function","datePublished":"2018-07-01T15:13:15+00:00","dateModified":"2023-11-03T11:09:11+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/"},"wordCount":291,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/","url":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/","name":"RANDBETWEEN function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-01T15:13:15+00:00","dateModified":"2023-11-03T11:09:11+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/randbetween\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/randbetween\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"RANDBETWEEN function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1175"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1175"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1175\/revisions"}],"predecessor-version":[{"id":16533,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1175\/revisions\/16533"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}