OK time to talk about some of my favorite functions in Excel the rand and ran between functions.
So these are essentially random number generators and they work in slightly different ways.
The first is the rand function and when you write it you literally just open and close the parentheses
without anything in between.
Just like you see here there are few functions in Excel like today and now which will cover the date
and time section where you write it this way there's there's actually no components of the formula besides
the formula name itself.
And what the rand function does is it returns a random number between 0 and 1 out to I believe 15 digits
ran between is similar except that you can specify the range that you want to determent and it will
return whole numbers between your range.
So if I wrote ran between zero comma one hundred and filled out this array from a 1:36 Here's an example
of what I might see.
Keep in mind these are volatile functions meaning that they'll recalculate or read randomise with any
workbook change so just be aware.
I'm going to jump into just a blank Excel workbook to really quickly show you what these look like in
cell a 1 and do a rand function.
So just R A N D.
Open Closed parentheses enter I am gonna see and drag out drag it over and it's just giving me a series
of random numbers between 0 and 1.
And if I go to the formulas tab could calculate.
Now you'll see they consistently change.
Now I will just change instead of Rande.
I'll do Rande between and let me just say 0 to 100 and then close the parentheses and let's apply that
to the same range.
You'll see that I'm dealing with a similar random number generator except in this case all my numbers
are whole numbers between 0 and 100.
So there you go two examples of random number generators in Excel using Rand and Rand be to