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.