你这个实际只能取正负0.1,0.2,0.3共6个值所以可以按如下来=IF(RAND()>0.5,1,-1)*RANDBETWEEN(1,3)/10
=ROUND(RAND()*(0.6)-0.3,1) 复制它粘贴到单元格
=ROUNDUP(IF((RAND()*0.6-0.3)<>0,RAND()*0.6-0.3,(RAND()*0.6-0.3)+0.1),1)
