Share this article:

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