小弟是做工程试验的,需要四舍六入五单双的修约方法,因此求个再excel中...答:两位小数:=IF(C2>(CEILING(C2,0.001)+FLOOR(C2,0.001))/2,CEILING(C2,0.001),IF(C2<(CEILING(C2,0.001)+FLOOR(C2,0.001))/2,FLOOR(C2,0.001),IF(MOD(RIGHT(TRUNC(C2,3),1),2)=0,TRUNC(C2,3),IF(TRUNC(C2,3)=C2,C2,TRUNC(C2,3)+0.001)))取二位小数时,把公式中的...