Formulas > =RANDBETWEEN()

How To Use RANDBETWEEN() Function in Google Sheets


Returns a uniformly random integer between two values, inclusive.

Common questions about the RANDBETWEEN formula in Google Sheets include:
What does the RANDBETWEEN formula do?
What is the syntax of the RANDBETWEEN formula?
What are the arguments required by the RANDBETWEEN formula?
How can I generate random numbers within a specific range using RANDBETWEEN?
Can I use RANDBETWEEN to generate decimal or non-integer numbers?

The RANDBETWEEN formula can be used appropriately in various scenarios, including:
Generating random numbers for simulations or modeling.
Creating randomized test data.
Randomly selecting items from a list or assigning random values to a set of options.
Conducting games or competitions that require random outcomes.

The RANDBETWEEN formula can be commonly mistyped in a few ways, such as:
Misspelling the formula name as RANDABETWEEN or RANDOMBETWEEN.
Incorrectly using uppercase letters in the formula (e.g., RandBetween).
Omitting the required arguments or using them in the wrong order.

Some common ways the RANDBETWEEN formula is used inappropriately include:
Using RANDBETWEEN as a source of security or encryption, which is not reliable as it's a pseudo-random number generator.
Relying on RANDBETWEEN for important business decisions or critical calculations, as the generated numbers are not truly random and can change upon recalculation.
Using RANDBETWEEN excessively in large datasets or complex formulas, which can cause performance issues.

Common pitfalls when using the RANDBETWEEN formula are:
Forgetting to lock the cell reference if the formula needs to be copied to other cells.
Assuming that the generated numbers will remain static unless manually refreshed or recalculated.
Overlooking the fact that RANDBETWEEN will recalculate whenever any change occurs in the sheet, potentially affecting other formulas or calculations.

Common mistakes when using the RANDBETWEEN formula include:
Not specifying the correct range for the arguments, resulting in incorrect or unexpected random numbers.
Using non-integer values for the range arguments, which will lead to an error or undesired outcomes.
Neglecting to use the INT function if integer values are required, as RANDBETWEEN alone can generate decimal numbers.

Common Misconception about RANDBETWEEN
A common misconception people might have with the RANDBETWEEN formula is Believing that the generated numbers are truly random. In reality, RANDBETWEEN relies on a pseudo-random number generator and the sequence of numbers can be predictable if the same seed value is used or if the sheet is recalculated.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

How To Actually Use RANDBETWEEN() in Sheets

RANDBETWEEN(low, high)

4Better Sheets Tutorials

I'll show you how to create a motivational quote checklist that generates a random quote every time you check off a task. We'll start from scratch and create a formula that displays motivational quotes from a list of 100 quotes. The quotes can be easily expanded, and the checklist will update accordingly. This tool will add a touch of motivation and productivity to your day. Enjoy!
Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.
generate random numbers using Google Sheets. Fun ways to figure out how to get random characters. Great to use for creating IDs or Coupon Codes. Nice easy intro to some simple apps script.
Created a daily email with a motivational quote in the subject.

Learn more about the RANDBETWEEN() formula:

Rand & Randbet

Discover the RAND and RANDBET functions. Select the HD quality option for the best full-screen viewing experience. Visit for more videos and tutorials!

Generate a RANDBETWEEN() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.