excel 随机函数正负5,但是不要正负2之间的数,怎么弄答:=IF(RANDBETWEEN(0,1)=1,RANDBETWEEN(-5,-3),RANDBETWEEN(3,5))这个产生5,-4,-3,3,4,5 =IF(RANDBETWEEN(0,1)=1,RANDBETWEEN(-50,-21),RANDBETWEEN(21,50))/10 这个产生-5到-2.1,2.1到5的 =IF(RANDBETWEEN(0,1)=1,RANDBETWEEN(-500,-201),RANDBETWEEN(201,500))/100 这个...