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

[µo°Ý] Àx¦s®æ¬°ªÅ¥Õ,¦ý¨Ï¥Î¨ç¼Æ«o¥X²{0

[µo°Ý] Àx¦s®æ¬°ªÅ¥Õ,¦ý¨Ï¥Î¨ç¼Æ«o¥X²{0

½Ð±Ð¦U¦ì«e½ú¬°¦ó¨Ï¥Î¦p¤U¨ç¼Æ,Àx¦s®æ¬°ªÅ¥Õ®É,µ²ªG¥X²{0,½Ð±Ð¦p¦ó­×§ï¤~¯à¨ÏÀx¦s®æ¬°ªÅ¥Õ®É,µ²ªG¤]¥X²{ªÅ¥Õ?
·PÁ½ç±Ð!
=IF(ISERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

¦^´_ 1# onegirl0204


    ISERROR §ï¬° ISBLANK ¸Õ¬Ý¬Ý§a

TOP

¦^´_ 1# onegirl0204

Àx¦s®æ~¦Û­q
0;; _0;;

TOP

=IF(B4="","",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦b¤½¦¡³Ì«á¥[¤W &""

TOP

§ï¥ÎISBLANK ~Àx¦s®æ¥X²{¤½¦¡¤º®e¦p¤U
=IF(ISBLANK(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

Àx¦s®æ~¦Û­q0;; _0;;
µ²ªG¤]¥X²{¿ù»~


§ï¥Î¨ç¼Æ=IF(B4="","",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))~Àx¦s®æ¥X²{¤½¦¡¤º®e¦p¤U
=IF(B4="","",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

¦b¤½¦¡³Ì«á¥[¤W &"" ~Àx¦s®æ¥X²{¤½¦¡¤º®e¦p¤U
=IF(ISERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))&""

TOP

¦^´_ 6# onegirl0204


Àx¦s®æ¬°ªÅ¥Õ®É, µ²ªG¤]¥X²{ªÅ¥Õ, ¤½¦¡ :

1. Excel 2007 ©Î¥H¤Wª©¥», E2 ¤½¦¡¦V¤U½Æ»s :

=IF(D2="","",IFERROR(1/(1/(VLOOKUP(D2,A$2:B$6,2,0))),""))

2. Excel 2003 ©Î¥H¤Uª©¥», F2 ¤½¦¡¦V¤U½Æ»s :

=IF(D2="","",IF(ISERROR(1/(1/(VLOOKUP(D2,A$2:B$6,2,0)))),"",VLOOKUP(D2,A$2:B$6,2,0)))

TOP

¦^´_ 1# onegirl0204
=IF(ISERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))
§ï为
=IF(IFERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))

   ISERROR  §ï为   IFERROR

TOP

¦^´_  onegirl0204......§ï为
=IF(IFERROR(VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0)),"",VLOOKUP(B4,§Ó¤u¸ê®Æ,7,0))....


°ò¥»¤W, §A¤£À´±o¦p¦ó¨Ï¥Î IFERROR !

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD