Getting random numbers

If you want to get random numbers between two numbers, you use RANDBETWEEN() function. First, you write the bottom number, secondly you write top number. 

If you use more RANDBETWEEN() function in a datasheet, in each enter click, all RANDBETWEEN() functions work again.

Moreover, when a new formula is entered, all RANDBETWEEN() functions find a new number again.

 If you want to write the chosen number more times, you use REPT() function with RANDBETWEEN() function as you see in example.

Related Trainings

Badly Formatted Data

Badly Formatted Data

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.


International Tourist Data

International Tourist Data

Calculate which country recieves the most tourists in each continent.


Travel Budget

Travel Budget

Create a "Travel Budged" sample.