{"id":3428,"date":"2014-03-04T15:23:44","date_gmt":"2014-03-04T09:53:44","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3428"},"modified":"2023-09-29T15:22:39","modified_gmt":"2023-09-29T09:52:39","slug":"excel-randbetween-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-randbetween-function\/","title":{"rendered":"How to Use Excel RANDBETWEEN Function (Examples + Video)"},"content":{"rendered":"<h2>Excel RANDBETWEEN Function (Example + Video)<\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-3282\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/RANDBETWEEN-FORMULA-EXCEL.png\" alt=\"Excel RANDBETWEEN Function\" width=\"450\" height=\"330\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/RANDBETWEEN-FORMULA-EXCEL.png 752w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/RANDBETWEEN-FORMULA-EXCEL-409x300.png 409w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<h3><span style=\"color: #800000;\">When to use Excel RANDBETWEEN Function<\/span><\/h3>\n<p>RANDBETWEEN function can be used when you want to generate evenly distributed random numbers between\u00a0a top and bottom range specified by the user.<\/p>\n<h3><span style=\"color: #800000;\">What it Returns<\/span><\/h3>\n<p>It returns a number between the top and bottom range specified by the user.<\/p>\n<h3><span style=\"color: #800000;\">Syntax<\/span><\/h3>\n<p>=RANDBETWEEN(bottom, top)<\/p>\n<h3><span style=\"color: #800000;\">Input Arguments<\/span><\/h3>\n<ul>\n<li><b>bottom &#8211;\u00a0<\/b>The smallest integer RANDBETWEEN will return.<\/li>\n<li><strong>top &#8211; <\/strong>The largest integer RANDBETWEEN will return.<\/li>\n<\/ul>\n<h3><span style=\"color: #800000;\">Additional Notes<\/span><\/h3>\n<ul>\n<li>RANDBETWEEN is a <a href=\"https:\/\/trumpexcel.com\/excel-volatile-formulas\/\" target=\"_blank\" rel=\"noopener noreferrer\">volatile function<\/a>\u00a0and should\u00a0be used with caution\n<ul>\n<li>It recalculates whenever the excel workbook is open or whenever a calculation is triggered in the worksheet. This means that the value of RAND keeps on changing.\n<ul>\n<li>Since volatile functions re-calculates so often, it adds to the processing time and slow down your workbook.<\/li>\n<\/ul>\n<\/li>\n<li>It can be forced to recalculate by pressing the F9 key. This\u00a0recalculates the entire workbook calculations<\/li>\n<\/ul>\n<\/li>\n<li>If you want to use RANDBETWEEN to generate a random number but don\u2019t want the numbers to change every time the cell is calculated, you can enter =RANDBETWEEN(bottom, top) in the formula bar, and then press F9 to change the formula to a random number.<\/li>\n<\/ul>\n<h3><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel RANDBETWEEN Function &#8211; Live Example<\/span><\/span><\/h3>\n<p><iframe src=\"https:\/\/onedrive.live.com\/embed?cid=7A7F3A8F4121E599&amp;resid=7A7F3A8F4121E599%21173&amp;authkey=AGsyd2wWKrZd1Mo&amp;em=2&amp;AllowTyping=True&amp;wdDownloadButton=True\" width=\"580\" height=\"400\" frameborder=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel RANDBETWEEN Function &#8211; Video Tutorial<\/span><\/span><\/h2>\n<p><iframe title=\"RANDBETWEEN Formula in Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/X43cJ4P3jgk?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><strong><span style=\"color: #800000;\">Related Excel Functions:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-int-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel INT Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-mod-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MOD Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-rand-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RAND Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-round-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel ROUND Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-rank-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RANK Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-large-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel LARGE Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-max-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MAX Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-min-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MIN Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-small-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel SMALL Function<\/a>.<\/li>\n<\/ul>\n<p><strong><span style=\"color: #800000;\">You May Also Like the Following Excel Tutorials:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/generate-unique-random-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Generate Unique Random Numbers in Excel<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/random-group-generator-template\/\" target=\"_blank\" rel=\"noopener noreferrer\">Random Group Generator Template [FREE Download]<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/generate-random-numbers-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Generate Random Numbers in Excel<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel RANDBETWEEN Function (Example + Video) When to use Excel RANDBETWEEN Function RANDBETWEEN function can be used when you want to generate evenly distributed random numbers between\u00a0a top and bottom range specified by the user. What it Returns It returns a number between the top and bottom range specified by the user. Syntax =RANDBETWEEN(bottom, top) &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Use Excel RANDBETWEEN Function (Examples + Video)\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/excel-randbetween-function\/#more-3428\" aria-label=\"Read more about How to Use Excel RANDBETWEEN Function (Examples + Video)\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[153],"tags":[19],"class_list":["post-3428","post","type-post","status-publish","format-standard","hentry","category-excel-functions","tag-excel-how-tos"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=3428"}],"version-history":[{"count":0,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3428\/revisions"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=3428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=3428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=3428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}