Generate randomization number

=RANDBETWEEN(1,100)

if you want to generate the range of number just key in the above formula.

the above example show the random no between 1 and 100

for 1 to 100
=int((100-0.0001)*rand())+1

not everyone can use " randbetween "

u can try :

= 49 * rand()
〔　ｎｏ　ｓｐａｃｅ　〕

在　any blank　cell 　按　ｅｎｔｅｒ，　即出現　0.00 ~ 49.00

if u don't want the 小數點, format cell >> number　＞＞　ｄｅｃｉｍａｌ　ｐｌａｃｅｓ　改成　0