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