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

[µo°Ý] ¦p¦ó¨ú¥X¼Æ­È«e¨â¦ì¼Æ«áÀY¸É0

[µo°Ý] ¦p¦ó¨ú¥X¼Æ­È«e¨â¦ì¼Æ«áÀY¸É0

AÄæ¦ì¬°°Ó«~»ù®æ
BÄæ¦ì¬°¹ê»Ú¥X³f»ù®æ

ÅU«È¸g±`¬°¤F¹sÀYªº°ÝÃD¸ò¤½¥q§n±o¤£¥i¶}¥æ
©Ò¥H¤WÀY¬°¤F¤è«K·Q¯d¤U»ù®æ«e¨â¦ì¼Æ«áÀY¸É0
½Ð°Ý¦U¦ì«e½ú¡A¤½¦¡¸Ó¦p¦ó¼g¥X¡H

¦bb2¤WÁä¤J¤U¦C¤½¦¡¡A¦A©¹¤U©Ô§Y¥i
=LEFT(TEXT(A2,"@"),2)*10^(LEN(TEXT(A2,"@"))-2)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-11-17 13:13 ½s¿è

¦^´_ 1# pinkytortoise
Àx¦s®æB1¿é¤J
=INT(A1/POWER(10,LEN(A1)-2))*POWER(10,LEN(A1)-2)
©Î
=INT(A1/(10^(LEN(A1)-2)))*(10^(LEN(A1)-2))
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# mihsu2007


    ·PÁ«e½ú¡ã

TOP

¦^´_ 1# pinkytortoise

=ROUNDDOWN(A1,2-LEN(INT(A1)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD