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

[µo°Ý] Ãö©ó½Æ»s¸ê®Æ, "²¤¹LªÅ®æ"

[µo°Ý] Ãö©ó½Æ»s¸ê®Æ, "²¤¹LªÅ®æ"

¤£¦n·N«ä, ·Q«Ü¤[, ¤@ª½§ä¤£¨ì¾A¦Xªº§@ªk
ªí®æ A ¤w³z¹L³]©w¨ç¼Æ·j´M§ä¨ì¹ïÀ³ªº¼Æ­È,
¤½¦¡ " =IFERROR(LOOKUP(,0/(($C3=$C$12:$C$18)*(D$2=$D$12:$D$18)),$E$12:$E$18),"")"
ªí®æB¬O¤w¸g¦s¦bªº¸ê®Æ;
²{¦b·Q­n§âªí®æA ªº¸ê®Æcopy¨ìªí®æ B¤¤, ²£¥Íªí®æC
ªí®æA¤¤ªÅ¥Õ³¡¤À,¤£·|¥hÂл\ªí®æB¤¤ªº¸ê®Æ, ½Ð°Ý¸Ó¦p¦ó°µ©O?
¸ÕµÛ¥Î"²¤¹LªÅ®æ",  ¤£¹L¦ü¥G¤£¦æ,
ÁöµM¬OªÅ¥ÕÀx¦s®æ, ¤£¹L¸Ì­±ÁÙ¬O¦³¸ê®Æ
½Ð°ÝÁÙ¦³¤°»ò¤èªk??  ¸ê®Æµ§¼Æ¦³´X¤dµ§, ©Ò¥H¨S¿ìªk¤@µ§µ§¤â°Ê½Æ»s
ÁÂÁÂ~

Book-3.rar (34.95 KB)

¦^´_ 1# samlin0403

¨£ªí®æC¡A¦³±N¤½¦¡§ï¼g¹L~
Book-3.rar (35.37 KB)

TOP

¦^´_ 1# samlin0403

­Y¦³¹ï®æ´N¤£¥Î¥ý¬d¸ß
J12 =IF(J3>0,J3,IF(D3>0,D3,""))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

Hi tku0216~  
Sorry~ ¥i¥H¨q¤½¦¡¶Ü?  ¦]¬°§ÚµLªk¤U¸üªþ¥ó...ÁÂÁÂ

TOP

¦^´_ 4# samlin0403


  J12="=IF(ISERROR(LOOKUP(,0/(($C12=$C$12:$C$18)*(J$2=$D$12:$D$18)),$E$12:$E$18)),IF(ISBLANK(J3),"",J3),LOOKUP(,0/(($C12=$C$12:$C$18)*(J$2=$D$12:$D$18)),$E$12:$E$18))"¡A¦V¤U¦V¥k©Ô¡A½Æ»s¤½¦¡¡C

TOP

Hi tku0216, ML089 ~

¤Ó·PÁ¤F, ¥Ø«e¤w¸g¥i¥H§@·~. ¤£¹L§ÚÁÙ¦³¤@­Ó¤p°ÝÃD.

¥Ø«e§Ú§âªí®æC¤¤ªº¼Æ­È, ¥u¦³copy¼Æ­È¨ì¥t¤@­ÓÀÉ®×.

­ì¥»ªÅ¥ÕªºÀx¦s®æ·|¥X²{ " ' ",  ¥i¬O§Ú·s¶}¤@­ÓÀɮפS¤£·|

½Ð°Ý¬°¤°»ò·|³o¼Ë?? ÁÂÁÂ

TOP

¦^´_ 3# ML089

ÁÂÁÂ~
M¤j,¦pªG§Ú­n¥Hªí®æAªº¸ê®Æ¬°¥D, ªí®æB¬°»², ²£¥Íªí®æD, À³¸Ó­n¦p¦ó­×§ï?

Book-4.rar (35.94 KB)

TOP

¦^´_ 7# samlin0403

§Ú¸Õ¥X¨Ó¤F J20 "=IF(ISNUMBER(D3),D3,IF(J3>0,J3,""))"

TOP

¦^´_ 7# samlin0403

·íªí®æ¬O¬Û¦Pªº®É­Ô¡A´N¥Î¹ïÀ³¤ñ¸û¤ñ¸û²³æ¡Aªí®æ¤£¦P¤~¥Î¬d¸ß¤ñ¸û

¥HBªí¬°¥D¡AA ªí¬°»²
J12 =IF(J3>0,J3,IF(D3>0,D3,""))

¥HAªí¬°¥D¡AB ªí¬°»²
J20 =IF(D3>0,D3,IF(J3>0,J3,""))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089

M¤j~ ÁÂÁÂ
¦]ªí®æA¤¤¦³¨ç¼Æ, ¦pªGª½±µ¥Î§Aªº¤½¦¡, ¤Ï¦Ó¥X²{ªº¸ê®Æ·|¤£¥¿½T.

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD