What does it do?

Gives you a random number between 0 and 1

Formula breakdown:


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:



STEP 1: We need to enter the RAND function:



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 🙂



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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Vlookup in Multiple Excel Sheets What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another sheet´s column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLO...
Highlight All Excel Formula Cells Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done: 1.Select all the cells in your Excel worksheet by clicking on the top left hand corn...
SUMIF Function: Introduction The SUMIF function is used widely amongst spreadsheet users as it is a simple Excel function.  It allows you to Sum the values in a range that meet a criteria that you specify. So if you want to Sum a range of sales values that are above $3,000 then this is the best Excel func...
Advanced Sumproduct Function: Sum the Top 3 Sales ... This is probably the most advanced level a SUMPRODUCT function can reach and that is by including a nested array formula. In our example below we want to return the 3 Largest values from the North region and sum them up.  As we are asking our formula to perform multiple calcul...