Generate Random Numbers (Integers) in Microsoft Excel

http://www.TeachMsOffice.com

This tutorial shows you how to generate random integers or whole numbers in Microsoft Excel. You can generate a number between any two numbers in excel by using the RANDBETWEEN() function. Here, you learn how to make and use the randbetween() function and also how to update the random numbers making them change using the keyboard shortcut "F9" to 'refresh' the numbers. This also shows you how to create a list of randomly generated numbers.


To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions.

Have a great day!

---

Closed Caption:

here i'm going to show you how to get an
integer with a lower and upper limit
which is randomly generated so a number
for instance between 10 and 50 and
between 300 and 400 which is randomly
generated
there are many reasons you may want to
do this if you're using numbers for
simulation model sensitivity analysis a
range of things or if you just want to
create a large list of randomly
generated numbers within limits you're
going to use the rand between function
now it's only going to give you integers
so you will not get a decimal or a
fraction here let me show you how it
works equals R and between so ra ND
between open parenthesis now put the
bottom in which is the lowest number
that can occur so for here i want 10
comma now the top or the highest number
that you want to occur
and here that's going to be 50 so hit
enter and the randomly generated number
is 11
now let's do the same thing for the
number between 300 and 400 equals R and
between open parenthesis the bottom
three hundred comma now the top 400
close parenthesis enter so it's very
easy to do that now also note that this
number changed when i hit enter down
here also if you hit f9 the randomly
generated numbers are going to change
again within their limits so every time
that I press f9 the numbers are going to
change but they're always going to be
within their limits between 10 and 50
and then between 300 and 400
and also if you have the same formulas
so if i copy this down now ran between
here is exactly like this one
the numbers are not going to be the same
because they're randomly generated same
with this
that's how you generate large lists of
random integers