What does it do?

Gives you a random number between 0 and 1

Formula breakdown:

=RAND()

What it means:

=RAND(Will automatically choose a random number between 0 and 1)


Excel is able to do a lot of things that most users are unaware of!  One thing that amazes me & I use almost daily is its ability to create random numbers for me!

But why would I even need random numbers?

Random numbers in Excel are great if you want to fill in a column with random values so you can create quick charts or just do any kind of random Excel analysis.

One of my best uses of the RAND function in Excel is to create random numbers for a raffle draw!

Thankfully this is very easy to do with Excel’s RAND formula!

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: We need to enter the RAND function:

=RAND()

 

STEP 2: Do the same for the rest of the cells by dragging the RAND formula all the way down using the left mouse button.

Now we are able to get random numbers for all the entries without any bias!

I’m actually the winner in this case as I have the lowest value!

 

EXTRA TIP: Press the F9 button on your keyboard to refresh/update the RAND values until you get your desired result…with bias 🙂

 

HELPFUL RESOURCE:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

MATCH Function Intro The MATCH function in Excel returns the position of an item within a list or a range of cells.Say that you have a Price List and want to know in which position a certain item is located within that Price List, then you would use the MATCH function.Formula Breakdown: MATCH...
Sum the Last 7 Transactions with the Offset Functi... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
Sumproduct & Weighted Averages A quick way to calculate the weighted average of two lists of data is to use the Sumproduct formula.  A weighted average can be used to determine the average salary of employees, the average grade of an exam or the average selling price of a company´s stock list, as can been seen...
OFFSET Function Introduced What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...