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

[µo°Ý] ¬°¦ó¦P¼Ëªºª¬ªp¦P¤@¤½¦¡¡Aµª®×«o¤£¦P?

[µo°Ý] ¬°¦ó¦P¼Ëªºª¬ªp¦P¤@¤½¦¡¡Aµª®×«o¤£¦P?

¦b¦P¤@±ø¥ó¤U¨Ï¥Î¤U¦C¤½¦¡¡Aµ²ªG¦³ªº¦³¥X²{¼Æ¦r¡A¦³ªº«o¬OªÅ¥Õ
=IF(ISNA(AND(VLOOKUP($B3,CHOOSE({1,2},¤á§O,ª÷ÃB2),2)=0,VLOOKUP($B3,CHOOSE({1,2},¤á§O,¤é´Á2),2)<>"")),"",($H3*$I3/2*100))

¼úª÷½Ð»âTEST.rar (24.56 KB)

¬Ý¤£À´­pºâ±ø¥ó, ±N¥|ºØª¬ªp§PÂ_¥X¨Ó, ­n¦p¦ó­pºâ¦Û¤v¦A¨M©w:
=SUMPRODUCT((VLOOKUP(B3,¦¨¥æ©ú²Ó!B:P,{14,15},)="")*{1,2})+1

1.¦³¤é´Áª÷ÃB
2.¥u¦³ª÷ÃB
3.¥u¦³¤é´Á
4.¥þµL

TOP

¬Ý¤£À´­pºâ±ø¥ó, ±N¥|ºØª¬ªp§PÂ_¥X¨Ó, ­n¦p¦ó­pºâ¦Û¤v¦A¨M©w:
=SUMPRODUCT((VLOOKUP(B3,¦¨¥æ©ú²Ó!B,{14, ...
­ã´£³¡ªL µoªí©ó 2020-7-22 10:58

¹ï¤£°_¡A§Úªí¹F¤£²M·¡
·íB4Àx¦s®æ¤á§O©Ò¹ï·Ó¨ì¤é´Á2<>""¥Bª÷ÃB2=""¡A«h¤w½Ðª÷ÃB=($H4*$I4/2*100)¡C
¦pªG¤é´Á2=""¥Bª÷ÃB2=""¡A«h¤w½Ðª÷ÃBÀx¦s=""¡C
§Ú¨Ï¥Î
=IF(ISNA(AND(VLOOKUP($B4,CHOOSE({1,2},¤á§O,ª÷ÃB2),2)="",VLOOKUP($B4,CHOOSE({1,2},¤á§O,¤é´Á2),2)<>"")),"",($H4*$I4/2*100))  
¤£ª¾¬°¦ó³£²Å¦X¤é´Á2<>""¥Bª÷ÃB2=""¡A¦³³¡¤Àµª®×¬O¥¿½Tªº¡A³¡¤À«o¬OªÅ¥Õ?
¤£ª¾¦¡¤l­þ¸Ì¿ù¤F?
±z«ü¾Éªº¦¡¤l¡A§Ú¤£¤ÓÀ´¡A©Ò¥H¤]¤£ª¾«ç»ò¹B¥Î

TOP

¦^´_ 3# olisun

=IF(AND(VLOOKUP($B3,IF({1,0},¤á§O,¤é´Á2),2,)<>0,VLOOKUP($B3,IF({1,0},¤á§O,ª÷ÃB2),2,)=0),$H3*$I3/2*100,"")

¦³¤é´Á ¨Sª÷ÃB = ­pºâÃB
¨ä¥¦ªÅ¥Õ???
Å޿観ÂI¤£²M·¡~~

TOP

¦^´_ 4# ­ã´£³¡ªL

¤@¡B³o¸Ì§Ú¥u¬O­n§PÂ_¬O§_¬°²Ä¤G¦¸½Ð´Ú¡A©Ò¥H³]©w¤é´Á2<>""¡Bª÷ÃB2=""¡A¬O¥Nªí²Ä¤G¦¸½Ð´Ú¡A¤]´N¬O»¡¤w¸g½Ð¹L¤@¦¸´Ú¡A¦]¦¹¤w½Ðª÷ÃB´N·|­pºâ«e¦¸½Ð´Úªºª÷ÃB¡C
¤G¡B¦pªG¤é´Á2¡Bª÷ÃB2=""¡A¥Nªí¥»¦¸¬°²Ä¤@¦¸½Ð´Ú¡A´N¨S¦³¤w½Ðª÷ÃB¡A©Ò¥H¤w½Ðª÷ÃB=""¡C
    [attach]32319[/attach]

TOP

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