[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
There are many reasons why you may need a random number generator, such as creating sample datasets, testing code, or even playing dice. While the generation of true random numbers remains problematic, pseudo-random number generators are random enough for common uses, including those already mentioned above. Fortunately, Google Sheets provides three functions for random number generation: RAND, RANDARRAY, and RANDBETWEEN.<\/p>\n
In this guide, you will learn how to use the RAND, RANDARRAY, and RANDBETWEEN functions in Google Sheets. In addition to the step-by-step instructions on using each function, you will also learn how to combine them and use them in formulas.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”can-i-generate-a-random-number-with-goog” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
There are three Google Sheets functions you can use to generate random numbers. RAND generates decimals between 0 (inclusive) and 1 (exclusive). RANDARRAY works the same way but generates an array instead of a single number. RANDBETWEEN, however, generates integers between the boundaries you specify.<\/p>\n
From a strictly mathematical perspective, these are not true random number generators but pseudo-random number generators. However, unless you\u2019re currently working on a mathematical proof, the numbers generated should be random enough.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-use-the-rand-function-in-google-s” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Follow the steps below to use the RAND function<\/a> in Google Sheets.<\/p>\n 1. <\/strong>Open Google Sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-blank-sheet.webp” alt=”RAND function in Google Sheets \u2014 blank spreadsheet with cell A1 selected” title_text=”Blank spreadsheet with cell A1 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2. <\/strong>In an empty cell, type the RAND function as shown below. The function doesn\u2019t take any arguments, so inserting anything between the parentheses will lead to an error.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-type-rand-formula.webp” alt=”RAND function in Google Sheets \u2014 =RAND() typed into cell A1″ title_text=”=RAND() typed into cell A1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3. <\/strong>Press \u2018Enter\u2019 to generate the number.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-random-decimal.webp” alt=”RAND function in Google Sheets \u2014 cell A1 showing the random decimal 0.9904145949″ title_text=”Cell A1 showing the random decimal 0.9904145949″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4. <\/strong>Since RAND is a volatile function, it will generate a new number every time the sheet recalculates or refreshes.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-volatile-new-value.webp” alt=”RAND function in Google Sheets \u2014 A1 recalculated to 0.13509477, with the note volatile in B1″ title_text=”A1 recalculated to 0.13509477, with the note volatile in B1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5. <\/strong>If you need to create a static dataset for testing, you can do this by copying the cell or cells and using Edit > Paste special > Values only.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-paste-values-only.webp” alt=”Random number generator in Google Sheets \u2014 Edit menu open at Paste special, Values only” title_text=”Edit menu open at Paste special, Values only” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6. <\/strong>Like any other formula, you can grab the fill handle<\/a> and drag it to copy it to other cells.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-fill-handle-copy.webp” alt=”RAND function in Google Sheets \u2014 =RAND() copied down A1:A12, each cell with a new decimal” title_text=”=RAND() copied down A1:A12, each cell with a new decimal” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-use-the-randarray-function-in-goo” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you need to generate an array of decimal values, you don\u2019t need to use multiple instances of RAND. Instead, use RANDARRAY to specify the number of rows and columns you want. Like other dynamic array formulas<\/a>, it spills its results into the neighboring cells.<\/p>\n 1. <\/strong>Open Google Sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randarray-google-sheets-select-cell.webp” alt=”RANDARRAY in Google Sheets \u2014 empty column D selected next to the RAND value in A1″ title_text=”Empty column D selected next to the RAND value in A1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2. <\/strong>Type the RANDARRAY function in an empty cell.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randarray-google-sheets-type-function.webp” alt=”RANDARRAY in Google Sheets \u2014 =RANDARRAY( typed in D1 with the rows and columns tooltip” title_text=”=RANDARRAY( typed in D1 with the rows and columns tooltip” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3. <\/strong>For the first parameter, specify the number of rows you want in your array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randarray-google-sheets-rows-argument.webp” alt=”RANDARRAY in Google Sheets \u2014 10 entered as the rows argument in D1″ title_text=”10 entered as the rows argument in D1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4. <\/strong>For the second parameter, specify the number of columns you want to generate.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randarray-google-sheets-columns-argument.webp” alt=”RANDARRAY in Google Sheets \u2014 =RANDARRAY(10,4) with 4 as the columns argument” title_text=”=RANDARRAY(10,4) with 4 as the columns argument” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5. <\/strong>Press \u2018Enter\u2019 to get the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randarray-google-sheets-random-array.webp” alt=”RANDARRAY in Google Sheets \u2014 10 by 4 array of random decimals in D1:G10″ title_text=”10 by 4 array of random decimals in D1:G10″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-use-the-randbetween-function-in-g” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The syntax is =RANDBETWEEN(low, high), where low and high are the smallest and largest whole numbers you want. Both bounds are included, so =RANDBETWEEN(1, 6) works like rolling a die. Follow the steps below to use RANDBETWEEN to generate integers between the specified lower and upper bounds.<\/p>\n 1. <\/strong>Open Google Sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randbetween-google-sheets-select-cell.webp” alt=”RANDBETWEEN Google Sheets \u2014 empty cell F2 selected next to a block of random decimals” title_text=”Empty cell F2 selected next to a block of random decimals” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2. <\/strong>In an empty cell, type the RANDBETWEEN function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randbetween-google-sheets-type-function.webp” alt=”RANDBETWEEN Google Sheets \u2014 =RANDBETWEEN( typed in F2 with the low, high tooltip” title_text=”=RANDBETWEEN( typed in F2 with the low, high tooltip” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3. <\/strong>Add the upper and lower boundaries. In this case, the function will generate numbers between 1 and 100.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randbetween-google-sheets-low-high-bounds.webp” alt=”RANDBETWEEN Google Sheets \u2014 =RANDBETWEEN(1,100) with 1 and 100 as the bounds” title_text=”=RANDBETWEEN(1,100) with 1 and 100 as the bounds” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/randbetween-google-sheets-random-integer.webp” alt=”RANDBETWEEN Google Sheets \u2014 cell F2 showing the random integer 61″ title_text=”Cell F2 showing the random integer 61″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-set-upper-lower-boundaries-with-t” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this section, you will learn how to use RAND to generate random numbers from a range larger than the default (0-1). Follow the steps below to set an upper and lower boundary for the RAND function.<\/p>\n 1. <\/strong>Open Google Sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-lower-upper-bound-cells.webp” alt=”RAND with bounds in Google Sheets \u2014 lower bound 1 in B1, upper bound 100 in B2, A4 selected” title_text=”Lower bound 1 in B1, upper bound 100 in B2, A4 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2. <\/strong>In an empty cell, type the RAND function followed by the multiplication operator.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-multiplication-operator.png” alt=”RAND with bounds in Google Sheets \u2014 =RAND()* typed in cell A4″ title_text=”=RAND()* typed in cell A4″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3. <\/strong>Add the upper and lower boundaries so the full formula reads =RAND()*(B2-B1)+B1, where B1 holds the lower bound and B2 holds the upper bound.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-bounds-formula.png” alt=”RAND with bounds in Google Sheets \u2014 =RAND()*(B2-B1)+B1 referencing the bound cells” title_text=”=RAND()*(B2-B1)+B1 referencing the bound cells” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-google-sheets-random-decimal-in-range.png” alt=”RAND with bounds in Google Sheets \u2014 A4 showing 90.97386777, between 1 and 100″ title_text=”A4 showing 90.97386777, between 1 and 100″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-combine-the-rand-randbetween-func” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, RAND only generates decimal numbers between 0 (inclusive) and 1 (exclusive). RANDBETWEEN, on the other hand, only generates integers between an upper and lower boundary. Therefore, you can easily combine them to get decimals between the boundaries you specify.<\/p>\n For example, you can add RAND and RANDBETWEEN to get random decimals in a given range, just like in the previous example using RAND.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-randbetween-google-sheets-add.png” alt=”RAND and RANDBETWEEN in Google Sheets \u2014 =RAND()+RANDBETWEEN(1,100) returning 51.15250832″ title_text=”=RAND()+RANDBETWEEN(1,100) returning 51.15250832″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also use it to get a negative range by subtracting them, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-randbetween-google-sheets-subtract.png” alt=”RAND and RANDBETWEEN in Google Sheets \u2014 =RAND()-RANDBETWEEN(1,100) returning -12.4962634″ title_text=”=RAND()-RANDBETWEEN(1,100) returning -12.4962634″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To generate multiple values, grab the fill handle and drag it down as far as you need.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/rand-randbetween-google-sheets-fill-handle.png” alt=”RAND and RANDBETWEEN in Google Sheets \u2014 both formulas dragged down D1:E20, positive and negative decimals” title_text=”Both formulas dragged down D1:E20, positive and negative decimals” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you have seen, generating random numbers in Google Sheets is easy. There are three functions you can use separately or combine. The first function, RAND, takes no arguments and generates decimals between zero and one. The second function, RANDARRAY, works just like RAND but generates an array of decimals. You can specify the size of the array through the function\u2019s arguments: rows and columns. The third function, RANDBETWEEN, generates integers from a given range. You can specify the upper and lower limits of this range through the function\u2019s arguments.<\/p>\n You now know how to use all three functions in Google Sheets. You also know that they are volatile functions, so the values generated will change with every recalculation or refresh on that sheet. If you need static values, make sure that after you generate them, you copy them and use the special paste option to keep values only. Additionally, you know how to combine these functions and adapt them to suit your needs.<\/p>\n To round the decimals that RAND returns, use the ROUND formula<\/a>. To shuffle a list into random order, add a =RAND() column next to it and sort by that column with the SORT function<\/a>.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda como as f\u00f3rmulas RANDBETWEEN do Google Sheets retornam n\u00fameros inteiros aleat\u00f3rios entre dois limites e quando usar RAND ou RANDARRAY para obter decimais.<\/p>","protected":false},"author":2,"featured_media":262834,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-262811","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262811"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262811\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262834"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to use the RANDARRAY function in Google Sheets?<\/h2>\n
How to use the RANDBETWEEN function in Google Sheets?<\/h2>\n
How to set upper & lower boundaries with the RAND function in Google Sheets?<\/h2>\n
How to combine the RAND & RANDBETWEEN functions in Google Sheets?<\/h2>\n
Conclusion<\/h2>\n