excel

2010-12-10 1:40 am
random function
use excel 03 's function only.......thx

1a random odd number
1b random even number
2.1-300 divided by 3

回答 (2)

2010-12-18 10:53 pm
✔ 最佳答案
=ROUND((RAND() * 300) / 2, 0) * 2 + 1
=ROUND((RAND() * 300) / 2, 0) * 2

dun understand quesion 2

2010-12-18 14:54:29 補充:
you mean number between 1 - 300 and divisible by 3?

=ROUND((RAND() * 100), 0) * 3
2010-12-10 5:40 am


收錄日期: 2021-04-13 17:42:14
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20101209000051KK00768

檢視 Wayback Machine 備份