ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó©T©wÅã¥Üªº¼Æ­È¦ì¼Æ¡H

[µo°Ý] ¦p¦ó©T©wÅã¥Üªº¼Æ­È¦ì¼Æ¡H

½Ð°Ý¦³¨S¦³¤è«Kªº¤è¦¡¥i¥Hª½±µ©T©wÅã¥Üªº¼Æ­È¦ì¼Æ¡H
ÁÂÁ¤F¡C

¨Ò¦p¡G
1.23456 -> 1.235
12.3456 -> 12.35
123.456 -> 123.5
1234.56 -> 1234

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

1234.56 -> 1234  ¬O§_À³¬° 1235¥|±Ë¤­¤J???
¥ý²q­Ó:
=ROUND(A1,MAX(,4-LEN(INT(A1))))

=IF(A1>=1000,INT(A1),ROUND(A1,MAX(,4-LEN(INT(A1)))))

TOP

        ÀR«ä¦Û¦b : ­n¤ñ½Ö§ó¨ü½Ö¡D¤£­n¤ñ½Ö§ó©È½Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD