怎么在excel里输入10个特定的数据?

我想在一个单元格里自动随机显示范围在45-100中的10个数字,并且要保留两位小数,该如何输入?请高手指教!!
对了,10个数值之间,还要有逗号隔开.

举报该问题

推荐答案 2010-01-04

显示一个随机数的公式为：
=randbetween(4500,10000)/100

因为你要在一个单元格中显示，所以可以用连字符将10个这样的公式连接起来：
=RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100&","&RANDBETWEEN(4500,10000)/100

测试通过！

温馨提示：答案为网友推荐，仅供参考

当前网址：http://55.wendadaohang.com/zd/IeF48cQGQ.html

其他回答

第1个回答 2010-01-05

redstarw - 十二级的回答是正确的
但是兄台你忘了教人家家在分析工具库
默认情况下excel是没有randbetween这个函数的啦
操作
工具---加载宏--在分析工具库前打钩然后确定再使用这个公式就可以了

第2个回答 2010-01-04

可以用

=ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)& ","&ROUND(RAND()*56+45,2)

第3个回答 2010-01-04

=ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)&","&ROUND(RAND()*(100-45)+45,2)

第4个回答 2010-01-04

在一个单元格内显示用逗号隔开的10个数有困难，要在10个单元格内随机生成一定范围内的数据，可加载函数实现

第5个回答 2010-01-04

=100-RAND()*55,可以生成45-100之间的随机数,然后设置单元格格式,数值>两位小数