- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 44
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2025-2-20
               
|
¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-3-2 16:21 ½s¿è
¦^´_ 1# kim595
1. F38¤½¦¡: IF(D18=0,"",VLOOKUP(D18,sheet2!$B:$D,2,FALSE),1)
G38¤½¦¡: IF(D18=0,"",VLOOKUP(D18,sheet2!$B:$D,1,FALSE),1)
³o¼Ë§ì¤£¨ì¸ê®Æ¬O¥¿±`ªº¡A¦]¬°VLOOKUPn·j´MªºÈ¡A¥²¶·¦b¸ê®Æªíªº²Ä¤@Äæ¦ì
sheet2ªºBÄæ¬O¼È©ñ´Ú³æ¸¹¡A©Ò¥H§A·j´M¤£¨ìµo²¼¸¹½X
·íµM¡A§Anªºµª®×¤]¤£À³¸Ó¬O¹ïÀ³¨ìªº³æ¤@Àx¦s®æªºÈ
±q§Aªº½d¨Ò¤¤¬Ý¤£À´F38nªº¬O¤°»ò¡AY¬O¥[Á`sheet2!F3:F10µª®×¤]¤£¸Ó¬O29735
µo°Ý°ÝÃD½Ð±N§Aªº»Ý¨D´yz²M·¡¡A¥H¤@Ó¿ù»~ªº¤½¦¡§O¤H¬O²q¤£³z§Anªº¬O¤°»ò?
¤£ª¾¹D¬O¤£¬O³oÓ·N«ä?
F38=IF(D38="","",ROUND(SUM(OFFSET(Sheet2!$D$1,MATCH(D38,Sheet2!$D:$D,0)-1,2,8,))*1.05,0))
G38=TEXT(OFFSET(Sheet2!$D$1,MATCH(D38,Sheet2!$D:$D,0)-1,-2),"OF000000")
2.¿ý»s¥¨¶°±o¨ìªºµ{¦¡½X¡A¬O¥H¿ý»s®Éªº°Ê§@¬ö¿ý©Ò¦³°Ê§@
n¹F¨ìÀH¤u§@ÅܰʦÓÀHµÛÅܤƤº®e¡A¥²¶·¨Ì·Óªí¤¤·í®Éªº¸ê®Æª¬ºA¡A´M§ä³W«h¡A¦A¨Ì·Ó³W«hקïµ{¦¡°t¦X©Ò»Ý
§Ú¬Ý§Aªº·N«äÀ³¸Ó¬O«ö¤U«ö¶s´Nn·s¼W5Óªí®æ¡A§Ú·Q¨ìªº¸Õºâ¥XB3¥H¤U²Ä¤@Ó«D¦X¨ÖÀx¦s®æ¦ì¸m«á¡A¦A¥H°j°é°õ¦æ5¦¸½Æ»s°Ê§@
½Ð¸ÕµÛ»¡©ú§Aªº»Ý¨D¡A¤~¯à±o¨ì¥¿½T¸Ñµª |
|