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

¹F¦¨°ÝÃD(¤w¸Ñ¨M)

¹F¦¨°ÝÃD(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-2-18 16:05 ½s¿è

½Ð°Ý¦³¤j¤j¥i¥H¨ó§U¶Ü?

¬¡­¶Ã¯1.zip (13.34 KB)

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-17 22:47 ½s¿è

¦^´_ 1# koala2099

1.¹ï·Óªí§ï¤@¤U
2.©|¥¼¦Ò¼{¤W­­(¥u¦³³Ì°ªµ¥¯Å¦³¤W­­130%¶Ü? ¨ä¥L¨â­Ó§Cµ¥¯Å¨S¦³¤W­­? )

=VLOOKUP(K4,$B$5:$E$7,2,1)+IF(L4<0.9,0,VLOOKUP(K4,$B$5:$E$7,3,1)*(L4-0.9)*100)

¬¡­¶Ã¯1.rar (13.64 KB)

TOP

¦^´_ 2# register313


«D±`ÁÂÁ±zªºÀ°¦£3Q
¨ä¥L2­Óªº¤W­­¤]¬O130%

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2012-2-17 23:47 ½s¿è

¦^´_ 1# koala2099

H4=IF(L4<0.9,0,LOOKUP(K4*10^4,{0,5000000,10000000},{1000,1500,2000})+(MIN(L4*100,130)-90)*LOOKUP(K4*10^4,{0,5000000,10000000},{300,350,400}))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ register313 ©ó 2012-2-18 00:08 ½s¿è

¦^´_ 3# koala2099

=MIN(VLOOKUP(L4,$B$5:$F$7,5,1),VLOOKUP(L4,$B$5:$E$7,2,1)+IF(M4<0.9,0,VLOOKUP(L4,$B$5:$E$7,3,1)*(M4-0.9)*100))

¬¡­¶Ã¯1.rar (13.67 KB)

¸É¥R¥t1­Ó(ª`·N¦³¨ÇÀx¦s®æ¤§¤º®e"ªí¸Ì¤£¤@")
¬¡­¶Ã¯2.rar (13.77 KB)

TOP

¦^´_ 5# register313


   
    ¥R¤À¤F¸ÑÅo!Å¥¤j¤jªº«Øij±Nªí®æ­×§ï
·PÁ±zªº¨ó§U»P«ü¾É~

TOP

¦^´_ 4# Hsieh


   
¥Ø«e»Ý¾Ç²ßªº¦a¤èÁ٫ܦh
¶W¯Åª©¥D¤j¤j¬°§Ú¼gªº¸Ñµª¤£¤Ó²z¸Ñ
¦ý«DÁ·PÁ±zªº¨ó§U~¥Ø«e°ÝÃD¤w¸Ñ

TOP

¦^´_ 7# koala2099

³o¼Ëªº¼gªk¥u¬O±Nªí®æ¨Ï¥Î±`¼Æ°}¦C¨Óªí¥Ü
©Ò¥H¡A³oºØ¤è¦¡«K¥i¥H¬Ù²¤¹ï·Óªí®æ
¾ã­Ó¤½¦¡¤À¶}¸ÑŪ¤£Ãø²z¸Ñ
=IF(L4<0.9,0,LOOKUP(K4*10^4,{0,5000000,10000000},{1000,1500,2000})+(MIN(L4*100,130)-90)*LOOKUP(K4*10^4,{0,5000000,10000000},{300,350,400}))

¦]¬°¬O­n­pºâ¹F¦¨²vªº¹ê±o¼úª÷
·í¹F¦¨²v§C©ó90%«hµL¼úª÷
©Ò¥HIF§PÂ_¹F¦¨²vL4<0.9´N¶Ç¦^0
¦A¨Ó­pºâ90%¹F¦¨²vªºª÷ÃB(°ò¥»¼úª÷)

LOOKUP(K4*10^4,{0,5000000,10000000},{1000,1500,2000})
KÄæ¬O¥H¸U¤¸¬°³æ¦ì©Ò¥Hª÷ÃB¬OK4*10^4¡AK4­¼¥H10ªº4¦¸¤è
­pºâ¥X¹ê»Úª÷ÃBµM«á¦b{0,5000000,10000000}³o­Ó°}¦C¤¤¤ñ¹ï¡A±o¨ìªº§Ç¦C¦ì¸m¹ï·Ó¨ì{1000,1500,2000}³o­Ó°}¦Cªº¦ì¸mµM«á¶Ç¦^{1000,1500,2000}¹ï·Ó¨ìªº­È¡C

(MIN(L4*100,130)-90)«h¬O¹F¦¨²v¸ò130¨ú³Ì¤p­È¡AµM«á´î¥h°ò¥»¹F¦¨²v90
±o¨ì¶W¹L90ªº³¡¤À¦b¥h­¼¥H¦¬¤J¹ï·Ó¨ìªº¨C¼W¥[1%ªº¼úª÷¡C
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 8# Hsieh


«z~­ì¨Ó¬O³o¼Ë
­ì¤£¤F¸Ñ>>> LOOKUP(K4*10^4,{0,5000000,10000000},{1000,1500,2000})
¦ý¦]¼úÀy¤Î¹F¦¨²v¤º®e°¸·|²§°Ê
·Q»¡¦³¹ï·Óªí¤è«K«áÄò­×¥¿®É¨Ï¥Î
¶W¯Åª©¥D¸ÑÄÀ«áÀ´¤F
«D±`Á±z^^¶O¤ß¸Ñ»¡

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD