Formulas > =RANDBETWEEN()
How To Use RANDBETWEEN() Function in Google Sheets
Description
How To Actually Use RANDBETWEEN() in Sheets
RANDBETWEEN(low, high)
Try RANDBETWEEN yourself
In cells A1 to A10, use the RANDBETWEEN formula to generate random integers between 1 and 100. Ensure each cell contains a different random integer.
Hints (2)
-
Remember to specify the low and high values for the range.
-
You can drag the formula down to fill the other cells.
6 Better Sheets Tutorials
5 Ways to Create Coupon Codes | Create UUIDs
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.
CHAR()
DEC2HEX()
MID()
RANDBETWEEN()
5 Ways to Generate Random Numbers
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.
RAND()
RANDBETWEEN()
Send a Daily Email with Inspiring Quote - A Little Pick Me Up
Created a daily email with a motivational quote in the subject.
ARRAYFORMULA()
COUNTA()
IF()
LEN()
RANDBETWEEN()
Creating a Random Motivational Quote Checklist
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!
COUNTA()
INDEX()
RANDBETWEEN()
Study Better With Google Sheets
Made Ali Abdaal's study google sheet better.
COUNTA()
GOOGLETRANSLATE()
INDEX()
RANDBETWEEN()
VLOOKUP()
Pick a Raffle Winner with Number of Tickets
Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
ARRAYFORMULA()
IF()
INDEX()
JOIN()
RANDBETWEEN()
+3 more
Learn more about the RANDBETWEEN() formula:
Generate a RANDBETWEEN() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses RANDBETWEEN(). 2 free AI generations, no signup. Members get unlimited use.
Generate a RANDBETWEEN() formula