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

ExCElǧλ

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

οʽ =ROUND(A1,-3)

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

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

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

ѡ򡪡һõԪʽлѡѡֵѡʹǧλָȷͼ

1ֱӶԵԪáѡԪϵҼõԪʽ"֡ǩԶ塰ڡ͡#,##0.00ȷ"֡ǩѡ񡱻ҡȷ 2úʽʾʽ=text(a1,"#,##0.00")

AֵҪǧλָʽʾ 1ѡAУҼڵIJ˵ѡõԪʽ ͼһ 2ڣõԪʽеġ֡ǩѡֵڡʹǧλָǰСϹȷ ͼ 3ʵʾЧ ͼ

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

ExcelֲʾǧλΪݲֵʽıֵ ҪʾǧλҪתΪֵֵ ʾ 1ѡݣʼ-ǧλָûʾǧλ 2ѡݣ̾ţתΪֵ 3...

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