ªð¦^¦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

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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 : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD