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