Question

excel 随机函数，生成-1到1之间，不为0的保留两位位小数

=ROUND(-0.99+(0.99+0.99)*RAND(),2)

该怎么写才能使它不生成0
=IF(ROUND(RAND(),0),ROUNDUP(RAND()*0.99,2),-1*ROUNDUP(RAND()*0.99,2))

=(INT(RAND()*(99-1+1))+1)*IF(RAND()>0.5,-1%,1%)

=CHOOSE(INT(RAND()*2+1),,"-")&ROUND(RAND()*1+0.01,2)

以上3个都是正确的，非常感谢你们！！

Answer 1

学习一下。