Better Sheets

How to Use RAND() in Google Sheets

Description

Returns a random number between 0 inclusive and 1 exclusive.

How To Actually Use RAND() in Sheets

RAND()

Try RAND yourself

In cell A1, use the RAND() formula to generate a random number between 0 and 1. The result should be a decimal value greater than or equal to 0 and less than 1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Create a Guess The Number Game | Challenge!

Use random number generators to make a number guessing game.

Intermediate

RAND() ROUND()

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends!

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.

Beginner

COUNTA() INDEX() RAND() ROUND()

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.

Intermediate

RAND() RANDBETWEEN()

Announcing Sell Daily and How I Built Sell Daily

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.

Beginner

FILTER() HYPERLINK() IF() INDEX() MATCH() +3 more

Celebrate Your Completed Checklists

Learn how to use apps script to add emoji animations when you complete a checklist in Google Sheets.

Advanced Intermediate

COUNTA() COUNTIF() FILTER() IF() IFNA() +3 more

Open Spreadsheet to Motivational Quote Automatically

Create a simple script to open a particular tab. In this case we're opening to a random motivational quote each time.

Beginner

COUNTA() INDEX() RAND() ROUNDUP()

Transcript-matched member videos for RAND(). Click through to watch.

Watch more tutorials

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Unlock these tutorials

Learn more about the RAND() formula:

Generate a RAND() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses RAND(). 2 free AI generations, no signup. Members get unlimited use.

Generate a RAND() formula

How to Use RAND() in Google Sheets

Try RAND yourself

Create a Guess The Number Game | Challenge!

Insert Random New Quotes in Your Google Sheets (Every Edit/Open)

5 Ways to Generate Random Numbers

Announcing Sell Daily and How I Built Sell Daily

Celebrate Your Completed Checklists

Open Spreadsheet to Motivational Quote Automatically

More related tutorials

Calculate ROAS in Google Sheets

Hardest Formula: SumIF | Addition Based on Dates / Values

Write Apps Script to Create a New Google Sheets Formula

Ultimate Checklist in Google Sheets