Returns a random integer number between the numbers you specify.
Söz dizimi
RANDBETWEEN(bottom, top)Bağımsız değişkenler
bottomzorunlu
The smallest integer that the function will return.
topzorunlu
The largest integer that the function will return.
The RANDBETWEEN function generates a random integer that falls within a specified range. Every time the worksheet calculates, a new random number is returned.
=RANDBETWEEN(1, 100)→42Returns a random integer between 1 and 100.
Select a cell
Click on the cell where you want to display the random number.
Enter the formula
Type =RANDBETWEEN(bottom, top) and press Enter.
No, it only returns whole integers.