Generate randomization number
2007-08-07 11:47 pm
I want to generate randomization number from excel program. would anybody tell me how to do it. many thz
回答 (3)
2007-08-07 11:53 pm
✔ 最佳答案
=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
參考: me
2007-08-10 8:00 pm
for 1 to 100
=int((100-0.0001)*rand())+1
=int((100-0.0001)*rand())+1
2007-08-10 2:01 am
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
u can try :
= 49 * rand()
〔 ｎｏ ｓｐａｃｅ 〕
在 any blank cell 按 ｅｎｔｅｒ， 即出現 0.00 ~ 49.00
if u don't want the 小數點, format cell >> number ＞＞ ｄｅｃｉｍａｌ ｐｌａｃｅｓ 改成 0
收錄日期: 2021-04-23 20:01:18
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070807000051KK03006