用EXCEL想随机生成1组随机数,使得超出一个范围的数字出现概率为10%请问...答:=IF(B2>=1,1,"")=IF(B4="","",IF(B4+1>$B$2,"",B4+1))=IF(B4="","",RANDBETWEEN(1,4))=IF(D2>=1,1+B2,"")=IF(D4="","",IF(D4+1>$D$2+$B$2,"",D4+1))=IF(F2>=1,1+B2+D2,"")=IF(F4="","",IF(F4+1>$F$2+$B$2+$D$2,"",F4+1))=...