Returns a random integer number between the numbers you specify.
Cú pháp
RANDBETWEEN(bottom, top)Đối số
bottombắt buộc
The smallest integer that the function will return.
topbắt buộc
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.