標題:

excel

發問:

random function use excel 03 's function only.......thx 1a random odd number 1b random even number 2.1-300 divided by 3 更新: 03 EXCEL CANNOT USE OLD AND EVEN

最佳解答:

=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

其他解答:

此文章來自奇摩知識+如有不便請留言告知

See follow solution from Joe, thx. http://hk.knowledge.yahoo.com/question/question?qid=7010120101646A215E4A27F624C16

arrow
arrow
    創作者介紹
    創作者 dvhtlbz 的頭像
    dvhtlbz

    dvhtlbz的部落格

    dvhtlbz 發表在 痞客邦 留言(0) 人氣()