- ·上一篇：excel如何计算回款
- ·下一篇：excel如何计算提成和个税
excel如何插入随机数函数
2025-12-05 09:35:22
1.怎么在excel里插入随机数字
1000000-9999999的整数
=RANDBETWEEN(1000000,9999999)
或
=INT(RAND()*(9999999-1000000)+1000001)
或
=INT(RAND()*(9999999-1000000))+1000001
或
=CEILING(RAND()*(9999999-1000000)+1000001,1)
或
=CEILING(RAND()*(9999999-1000000),1)+1000001
下拉填充
1000000-9999999的小数
=RAND()*(9999999-1000000)+1000000
下拉填充