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

[µo°Ý] ·Q¦p¦ó¤~¥i¥H±N#N/Aªº­ÈÅã¥Ü¬°0

[µo°Ý] ·Q¦p¦ó¤~¥i¥H±N#N/Aªº­ÈÅã¥Ü¬°0

¦¨¥\¶Ç¦^§Ú­n±o­È
=IF( ISBLANK(A329), "",VLOOKUP(A329,'1O4'!$A:$B,2,FALSE))
¦ý¦³¨Ç¬O·|¶Ç¬°#N/A
#N/A¬O¦]¬°¦b´M§ä¸ê®Æ¤¤µL
·Q¦p¦ó¤~¥i¥H±N#N/Aªº­ÈÅã¥Ü¬°0  ?
¦]¬°ÁÙ­n­pºâ
½Ð¨ó§U

=IF( ISBLANK(A329), "0",VLOOKUP(A329,'1O4'!$AB,2,FALSE))
¤£ª¾¬O§_¥¿½T?½Ð´ú¸Õ

TOP

if(isna(isblank(a329)),IF( ISBLANK(A329), "",VLOOKUP(A329,'1O4'!$AB,2,FALSE)),"")


¸Õ¸Õ³o­Ó,¥ý§âN/AªºÅܦ¨0,¦A­pºâ§Aªº¤½¦¡

TOP

¥»©«³Ì«á¥Ñ owen06 ©ó 2014-4-7 14:01 ½s¿è

¦^´_ 1# janejacky

=If(iserror(VLOOKUP(A329,'1O4'!$A:$B,2,FALSE)),"0",VLOOKUP(A329,'1O4'!$A:$B,2,FALSE))

  "0"¡G¦]¬°0¬O¼Æ­È¡A©Ò¥H¥i¥H¤£¥Î""¡A®t§O¦bÅã¥Ü¥X¨Óªº¼Æ¦r¾a¥ª©Î¾a¥k¦Ó¤w°Õ@@

TOP

ÁÂÁÂ
lp986749  mannings ³o¼Ë¬O¤£¦æªº
owen06 ¦ý³o¼Ë¨Ï¥ÎÁÙ¬OµLªk¥[Á`

TOP

¦^´_ 5# janejacky


    ¤£¯à¥[Á`ªº¸Ü¡A§A¥i¯à»Ý­n§ä¤@¤U§A¬O¤£¬O­þÃ䦳§Ë¿ù¤F¡C

Book1.rar (1.55 KB)

TOP

IF(   IF( ISBLANK(A329), "",VLOOKUP(A329,'1O4'!$AB,2,FALSE))=#N/A,
     "0",    IF( ISBLANK(A329), "",VLOOKUP(A329,'1O4'!$AB,2,FALSE)))

ÃöÁä ¦b§Aªº­È¬°NA  ´NÅý¦oÅã¥Ü0  ¦pªG¤£¬O  ´N¦b°µ§A­ì¥»¤½¦¡

TOP

ªü°a   iwiniwin  ÁÂÁÂ
ªü°a ±zªºOK

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD