What it does: The RANDBETWEEN() Function generates a random number between two integers.
Plain English: Rather than generating a random number between 0 and 1, RANDBETWEEN() generates an integer between a given range of integers that you provide. For example, you may want to pick 6 random lottery numbers between 1 and 35. This formula could help generate those.
Arguments: RANDBETWEEN(lower number, higher number)
- Lower number – the lowest integer possible you want to generate
- Higher number – the highest integer possible you want to generate
Blog Posts using RANDBETWEEN()
Videos using RANDBETWEEN()
What it does: The RAND() Function generates a random number between 0 and 1.
Plain English: The random function is a brother to the RANDBETWEEN() function. It generates a number in between 0 and 1, like .6231. This is a great function for creating sample data or running simulations where you need a random number generated.
- (no arguments needed for this function)
Blog Posts using RAND()
Videos using RAND()
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the number of days since January 1, 1900.” Let’s look at an example:
Believe it or not, these are actually the same date. The only difference is that B2 is formatted as a date, while D2 is not.
Since dates are calculated by Excel so easily, finding the difference between two dates is easy as well.
After putting March 5th into cell D2, I created a formula in F2: “=D2-B2”.
That’s it! We now have the total number of days in between those two numbers.
Dates and Times
Let’s look at this problem. We have 9 racers who all started at 10:30am. They finished at very different times. We tried to quickly check their race times using a simple subtraction formula, but we get an error. This is because the times are not formatted in a proper date format.
Using Text to Columns, we separate the “PST” from the rest of the format. Next, we’ll make sure columns G and I have proper time format:
- Delete Columns H and J
- Change formatting on (now) Column I
- Select Custom format and “hh:mm:ss”. As you can guess, this formats the result in hours, minutes, and seconds.
We can now see how long it took every member of the race to finish.