excel怎么取随机数

excel

1个回答

写回答

859076828

2026-01-05 19:01

+ 关注

excel
excel

根据您的需求,我可以为您提供以下解决方案:对于excel 2007版:在A2单元格中输入以下公式:((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND())((35-ROW())*RAND()

excel 2003版本中,您可以使用以下公式来实现同样的效果:在A2单元格中输入以下公式:((35-ROW())*RAND()((35-ROW())*RAND()

同时按下Ctrl+Shift+Enter键输入数组公式。然后,使用自动填充柄将以下公式填入A$1:A$33单元格中:在A$1:A$33单元格中输入以下公式:((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()((35-ROW())*RAND()

这样,您就可以生成随机数填充32行了。请注意,在excel 2007版本中使用上述公式时,需要确保A1单元格中不输入任何数字或文本,否则会导致错误。

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号