- ©«¤l
- 183
- ¥DÃD
- 14
- ºëµØ
- 0
- ¿n¤À
- 227
- ÂI¦W
- 115
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-8-8
- ³Ì«áµn¿ý
- 2024-5-12
|
¥»©«³Ì«á¥Ñ aer ©ó 2014-1-5 14:08 ½s¿è
¦^´_ 1# dragonbx
¸Õ¸Õ¸ê®Æ³]©w¬°¤å¦r®æ¦¡¡A¤½¦¡
=IF(--RIGHT(A1,1)>=5,LEFT(A1,3)&"5",LEFT(A1,3)&"0")
¦V¥k¡B¦V¤U½Æ»s
¦pªG©T©w¤G¦ì¤p¼Æ¡A¦ý¬O¤p¼ÆÂI¥ªÃä¼Æ¦r¤£©w®É¡A¥i§ï¥Î¤U¦C¤½¦¡
=IF(--RIGHT(A1,1)>=5,LEFT(A1,LEN(A1)-1)&"5",LEFT(A1,LEN(A1)-1)&"0") |
|