修约结果示例结果四舍六入五成双 2.52保留一位,修约到0.521.7421.5保留两位,修约到0.05 1.28 1.30
=IF(ROUND(B2*2,1)=ROUND(B2*2,0),IF(MOD(ROUNDDOWN(B2,0),2)<>0,ROUNDUP(B2,0),ROUNDDOWN(B2,0)),
=IF(B3*2-0.5=ROUNDDOWN(B3*2,0),IF(MOD(ROUNDDOWN(B3*2,0),2)<>0,ROUNDUP(B3*2,0)/2,ROUNDDOWN(B3*2,0)/2 =IF(B4*2-0.05=ROUNDDOWN(B4*2,1),IF(MOD(ROUNDDOWN(B4*20,0),2)<>0,ROUNDUP(B4*20,0)/20,ROUNDDOW
,0)),ROUND(B2,0)
,ROUNDDOWN(B3*2,0)/2),ROUND(B3*2,0)/2)
NDDOWN(B4*20,0)/20),ROUND(B4*20,0)/20)