Excel按权重产生随机数怎么编辑公式答:取整数:=IF(RAND()<=0.05,RANDBETWEEN(6,9),IF(RAND()>=0.95,RANDBETWEEN(20,23),RANDBETWEEN(10,19)))如果要小数:=IF(RAND()<=0.05,RANDBETWEEN(6,9)+RAND(),IF(RAND()>=0.95,RANDBETWEEN(20,23)+RAND(),RANDBETWEEN(10,19)+RAND()))函数RAND():生成[0,1)区间(前闭后开...