yhkn.net
ǰλãҳ >> ExCElǧλ >>

ExCElǧλ

ͨԶ嵥Ԫʽ Excel汾ο2010 1ѡA2A10Ԫ 2CTRL+1ϼԶ嵥ԪʽԻ 3Զ룺0, ȷ 4鿴ֻʾǧλݣ

ʹROUNDDOWNMID 1EXCEL룺=ROUNDDOWN(A1,-4)=MID(A2,1,3)&"0000" 2úЧ¡ֵжλROUNDDOWN

οʽ =ROUND(A1,-3)

=ROUND(E2,-3),뵽ǧλʽҪþȷΪʾȣһβʱŲӰֵ

빫ʽROUND() ڵǰԪ빫ʽ=ROUND(G1/1000,0) G1ΪУء

ó漴 Excel汾ο2010 A 1ѡA 2ʼ-- 3鿴Ч

֪¥Ƿְָ3λֽڼһţΪExcelǰݷֽڷõģҵ󣬸λʼÿ3λ֮һţԱĶ1,234,567ұ𣬵һǰǧλڶǰǰλǧǧ1ٶʮ34ǧ56...

=ROUNDDOWN(A1,-3)

赥ԪA1ùʽ λȡ =ROUND(A1,-3) ǧλȡ =ROUND(A1,-4)

ʽΪ =trunc(A1*0.7,-3) truncҪĺһҪݣڶλλΪָСλǸָСǰλ0дָٸӣ =trunc(1.25,1) ...

վҳ | վͼ
All rights reserved Powered by www.yhkn.net
copyright ©right 2010-2021
磬ַϵͷzhit325@qq.com