RANDBETWEEN – Excel Function

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()

  • Article 1

Videos using RANDBETWEEN()

  • Video 1

RAND – Excel Function

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.

Syntax: RAND()

  • (no arguments needed for this function)

Blog Posts using RAND()

  • Article 1

Videos using RAND()

  • Video 1

Dates in Excel – Part 1

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:

dates-in-excel

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.

dates2

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.

giphy-downsized-large

Dates and Times

dates3

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.

dates4

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:

dates5

  • Delete Columns H and J
  • Change formatting on (now) Column I

dates6

  • Select Custom format and “hh:mm:ss”. As you can guess, this formats the result in hours, minutes, and seconds.

dates7

We can now see how long it took every member of the race to finish.