wps表格奇进偶不进(用excel进位时,奇进偶不进)

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

公式向下复制

wps表格如何奇进偶不进