=IF(RAND()>0.5,RAND()*10000+10,RAND()*-10000-20)如图:如果只要整数,则公式为:=INT(IF(RAND()>0.5,RAND()*10000+11,RAND()*-10000-21))如图: