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

[µo°Ý] ¤½¦¡µ²ªG¬°¼Æ­È0­È®É¡A±a¥XªÅ¥Õ¦Ó«D¼Æ­È0

[µo°Ý] ¤½¦¡µ²ªG¬°¼Æ­È0­È®É¡A±a¥XªÅ¥Õ¦Ó«D¼Æ­È0

1.PNG
2016-4-25 20:33

½Ð°Ý¦p¦ó­×§ïBÄ椽¦¡¡AÅý¤½¦¡µ²ªG¦p¬°¼Æ­È0­È®É¡A±a¥Xµ²ªG¬°ªÅ¥Õ("")¡A¦Ó«D¼Æ­È0¡C
¦ý§Æ±æ¥H­×§ï¤½¦¡¸Ñ¨M¡A«D§ïÅÜÀx¦s®æ®æ¦¡©Î±ø¥ó¤ÆÁôÂÃ0­È¡C


ÁÂÁÂ~~~~~~~

´ú¸ÕÀÉ.rar (8.06 KB)
*¦v¤k¤@ªTµL»~*

©êºp¡A§Ú¬O¤p¾Ç¥Í¡AÁÙ¤£¯à¤U¸üÀÉ®×

¦ý¬O¨ç¼Æ¼gªk¦p¤U
=if(­ì¤½¦¡=0, "","­ì¤½¦¡")

TOP

¦^´_ 2# xgirlxs

X¤j~~~~«D±`·PÁÂÀ°¦££¬¡I¡I
*¦v¤k¤@ªTµL»~*

TOP

=TEXT(­ì¤½¦¡,"[=] ")

TOP

¦^´_ 1# msmplay

=IF(ISERROR(0/VLOOKUP(LEFT(C2,3),I:J,2,0)),"",VLOOKUP(LEFT(C2,3),I:J,2,0)*LOOKUP(0,-FIND({"¤@Âà¤T","°t°e"},A2),{2,1}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# hcm19522
¦^´_ 5# ML089

h¤j~~~M¤j~~~«D±`·PÁ§A­Ì¼ö±¡À°¦£³á!!!
*¦v¤k¤@ªTµL»~*

TOP

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