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

[µo°Ý] ¸ê®Æ±Æ°£°ÝÃD

[µo°Ý] ¸ê®Æ±Æ°£°ÝÃD

¤j¤j­Ì¦n,
½Ð°Ý¥H¤U°ÝÃD
CÄæ·|¦³ª«¬y°Óªº¦W¦r,¥Ø«e¤wª¾ ¥x¤¤.ªá½¬.°ª¶¯.¶³ªL,¬O§Ú¤£­nªº¸ê®Æ,¦ý­ì¸ê®Æ­n«O¯d,
§Ú¨Ì¾ÚCÄ檫¬y°Ó,¦bKÄæshow¥X§Ú­nªºª«¬y°Ó²ºÙ,§Ú­nªº§@¥Î¬O:
CÄæ¤@¥X²{§Ú­nªºª«¬y°Ó,´N¨Ì§ÇÅã¥Ü,¤@ª½¨ì¤U¤@­ÓCÄæ¥X²{·sªºª«¬y°Ó,¦pªG¬O§Ú­nªº´NÅã¥Ü·sªº,
¬O­n±Æ°£ªº,´N¥X²{ERR,¤@ª½¨ì¸ê®Æªº³Ì©³ºÝ,¦ý²{¦b¦³­Ó°ÝÃDµLªk¸Ñ¨M,¦³´X­Ó®Æ¸¹¤£¬O§Ú­nªº,
§Æ±æ¥¦¤]¥i¥H±Nª«¬y°ÓÅã¥Ü¬°ERR,§Ú±N»Ý­n±Æ°£ªº°Ó«~¶K¦bO1:P8
¥Ø«e§Ú¥Î¨ç¼ÆK2=IF(COUNTIF(C2,"¥x¤¤*")+COUNTIF(C2,"ªá½¬*")+COUNTIF(C2,"°ª¶¯*")+COUNTIF(C2,"¶³ªL*")=1,"ERR",IF(COUNTIF(C2,"ªL¤f*"),"¤ñµá¦h.ªL¤f¥þ¥x",IF(COUNTIF(C2,"¤K¼w*"),"¤ñµá¦h.¤K¼w¥þ¥x",IF(COUNTIF(C2,"¤j·Ë*"),"¤ñµá¦h.¤j·Ë¥þ¥x",K1))))
¥¦¥i¥H¥X²{§Ú­nªºª«¬y°Ó²ºÙ,¦ýµLªk±Æ°£¤£­nªº®Æ¸¹,±Nª«¬y°ÓÅܬ°ERR,½Ð°Ý¨ç¼Æ¥i¥H¦p¦ó­×§ï?
¸ê®Æ±Æ°£°ÝÃD.rar (29.9 KB)

¦^´_ 2# zheng211016

ÁÂÁ§A°Ú¡I³o¬O¥Ø«e°ß¤@ªº¤è®×¤F¡I
§Ú¦Û¤v¤@ª½¸Õ¤£¥X¥i¥H¤@­Ó¤½¦¡ºâ¥Xµª®×(¨Ò¦p¡GM2=....ªº³oºØ¤½¦¡),¦pªG¦³¨ä¥L§ó¦nªº¤èªk,½Ð¦A«ü¾É¤@¤U§Ö·Q¯}ÀYªº§Ú¡I

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD