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

½Ð°Ý¦p¦ó¥i¥H±N¶µ¥Ø­È¬°0ªºÀx¦s®æ¨ú¥N¬°³Ì±µªñªº¼Æ­È?

½Ð°Ý¦p¦ó¥i¥H±N¶µ¥Ø­È¬°0ªºÀx¦s®æ¨ú¥N¬°³Ì±µªñªº¼Æ­È?

¥»©«³Ì«á¥Ñ chaoyiho ©ó 2016-5-13 12:04 ½s¿è

ªþ¤W¹Ï¤ù

javascript:;

¦p¹Ï¤ù¡A³o¨Ç¦Ç¦âªº³¡¤À¥u­n¬°¹sªº³£·Q­n±N¥L¨ú¥N¬°³Ì±µªñªº¨º­Ó­È
½Ð°Ý¤½¦¡­n«ç»ò¼g©O?
¦pªG¤½¦¡µLªk¸Ñ¨M
¨ºÁÙ¦³¤°»ò¿ìªk©O?
½Ð±Ð¦U¦ì«e½ú

¸É¥R:´N¹³¹Ï¤ù¤¤ ¦³­Ó1400 0 1500 ªº¦a¤è ´N¥i¥H¨ú¥N¬°1400 ¦ý¬O¦pªG¼Æ¦rµLªkºô¤W·j´M¨ì«D¹sªº­È«h©¹¤U·j´M

Â^¨ú.PNG (11.27 KB)

Â^¨ú.PNG

{=IF(SUM(A$1:A1)=0,INDEX(A:A,MATCH(,0/A$1:A$99,)),LOOKUP(1,0/(A$1:A1),A$1:A$99))

TOP

¦^´_ 2# hcm19522

·PÁ«e½úªº¦^ÂÐ ¦]¬°³Ìªñ¥X®t­è¦^¨Ó ©Ò¥H²{¦b¤~¦^´_
¯uªº«D±`©êºp!
§Ú°¨¤W¸Õ¬Ý¬Ý!!

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD