如图根据尺寸(寸法)随机一个测定值且符合公差要求例20±0.02 即随机值应在19.98-20.02之间
=ROUND(RAND()*RIGHT(B2,4)*2^ISERR(-B2)+A2-RIGHT(B2,4)*(LEFT(B2)<>"+"),LEN(B2)-3)
å ¬å·®åäºä¸ç¹æ¹å¨ï¼æ¯0ï¼+1æè -1ï¼0è¿ç§çï¼å ¬å·®åªåäº+1æè -1ã
ç»ææå修约äºå°æ°ä½æ°ï¼è·å ¬å·®ç²¾åº¦ç¸åã