-
1.怎么用excel进位时,奇进偶不进
B2=ROUNDDOWN(A2,2)
C2=INT(MOD(A2,0.01)*1000)
D2=ROUNDDOWN(A2,2)+MOD(INT(MOD(A2,0.01)*1000),2)/100
公式向下复制
B2=ROUNDDOWN(A2,2)
C2=INT(MOD(A2,0.01)*1000)
D2=ROUNDDOWN(A2,2)+MOD(INT(MOD(A2,0.01)*1000),2)/100
公式向下复制