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)

Excelͼʾݡ ҪʹǧλֵָλһֿѡиУȻһѡõԪʽ 򿪡ԪʽԻڡ֡ѡࡱѡֵȻҲġʹǧλָǰĸѡѡȻ...

ԪʽԶΪ #,+k

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

1һհ׵Ԫ1000 2ƸõԪ 3һ2563ڵԪԪɰסCTRLжѡһԪ񣩣 4ѡ:ѡճ 5ѡ:ˣ 6OKˡ

B2ʽ=IF(A2>=10000,LEFT(RIGHT(TEXT(A2,"0.00"),8),1),"") C2ʽ=IF(A2>=1000,LEFT(RIGHT(TEXT(A2,"0.00"),7),1),"") D2ʽ=IF(A2>=100,LEFT(RIGHT(TEXT(A2,"0.00"),6),1),"") E2ʽ=IF(A2>=10,LEFT(RIGHT(TEXT(A2,"0.00"),5),1),"...

=ROUNDUP(A1,-4)

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

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