EXCEL数字修约公式中如何进行修约,拜请高手赐教!!!能有公式最好,谢谢...答:=IF(AND(ROUNDUP(B1,2)=B1,RIGHT(FIXED(B1,2))="5"),(B1>0)*(MOD(RIGHT(FIXED(B1,1)),2)=0)*0.1+ROUNDDOWN(B1,1),ROUND(B1,1))
...入五单双的修约方法,因此求个再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)))取二位小数时,把公式中的0.001改...
谁有EXCEL四舍六入五单双的数字修约公式答:三位有效数字的:=FIXED(FIXED(A1,2-RIGHT(TEXT(A1,"0.00E+00"),3),1)-(MOD(A1*10^(3-RIGHT(TEXT(A1,"0.00E+00"),3)),20)=5)*10^(RIGHT(TEXT(A1,"0.00E+00"),3)-2),2-RIGHT(TEXT(A1,"0.00E+00"),3),1)