½Ð°Ý´M§äªº¨ç¼Æ­n¦p¦ó³]

wind6424

[attach]12281[/attach]½Ð°Ý¦p¤U¹Ïªºªí®æ,
§Ú§Æ±æ¦b³Ì¤U¤èªºÁ`¼Æ¸ò¤À¼Æ¿é¤J­È,·|¦Û°Ê±a¥Xµûµ¥­È,·Q½Ð±Ð³o¨ç¼Æ­n¦p¦ó¼g,
¨Ò¤JÁ`¼Æ¿é¤J1300,·|§ä¨ì­n¤ñ¹ï(¬õ¦â®Ø®Øªº³¡¤À)¦ì¸m¬°1251~1500³o¤@Äæ
µM«á®Ú¾Ú¤À¼Æ1200 §PÂ_¬O¤j©ó975 ¤p©ó1350,
©Ò¥H¹ïÀ³µû¤À(¶À¦â®Ø®Øªº³¡¤À)¬°8

¤U¸ü (15.63 KB)

2012-8-25 10:52

ANGELA

=INDEX(A4:A14,MATCH(B17,OFFSET($A$4:$A$14,,MATCH(B16,B2:R2)))+1)

Hsieh

¦^´_ 1# wind6424
B18°}¦C¤½¦¡
=INDEX($A$4:$A$14,MATCH(1,1/(INDEX($A$4:$R$14,,MATCH(B16,$2:$2))>=B17),0),)

aer

½Ð°Ý¤U¦C¤½¦¡¤¤ªº$2: $2¬O¤°»ò·N«ä?
MATCH(B16,$2: $2)

Hsieh

¦^´_ 4# aer


    ²Ä¤G¦C¤¤´M§ä

wind6424

·PÁ ANGELA / Hsieh ª©¤j

wind6424

¦A½Ð±Ð¤j¤j­Ì¤@­ÓÃþ¦üªº°ÝÃD
¦p¹Ï
·íA¬°5®É,¹ïÀ³ªí¤ºAÄæ¤j©ó3¤p©ó8©Ò¥Hµ¥¯Å¬O6,
B¬°3®É,¹ïÀ³ªí¤ºBÄæ¤j©ó2¤p©ó5©Ò¥Hµ¥¯Å¬O8,
C¬°24®É,¹ïÀ³ªí¤ºCÄæ¤j©ó10¤p©ó40©Ò¥Hµ¥¯Å¬O9,
D¬°8®É,¹ïÀ³ªí¤ºDÄæ¤p©ó15©Ò¥Hµ¥¯Å¬O10
µ¥¯Å´N¨ú¥|­Ó³Ì¤p­È,©Ò¥H³Ì¤p­È¬°6

½Ð°Ý³o­Ó¨ç¼Æ­n¦p¦ó¼g,

A,B,C,D,¦U§Oµ¥¯Å¬O¦³¼Ò¥é¨â¦ìª©¤jªº¨ç¼Æ¥h§ï,
¦ý¬O¹ïÀ³ªºµ¥¯ÅÁÙ¬O³£·|¿ù»~,
©Ò¥H¥u¦n¦A¤W¨Ó½Ð±Ð
ÁÂÁÂ

¤U¸ü (12.64 KB)

2012-8-28 22:15

Hsieh

¦^´_ 7# wind6424

°}¦C¤½¦¡
=MIN(INDEX($E$4:$E$14,MATCH(1,1/(F4:F14>=F16),0),),INDEX($E$4:$E$14,MATCH(1,1/(G4:G14>=F17),0),),INDEX($E$4:$E$14,MATCH(1,1/(H4:H14>=F18),0),),INDEX($E$4:$E$14,MATCH(1,1/(I4:I14>=F19),0),))

wind6424

·PÁ Hsieh ª©¤j