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

[µo°Ý] ¹F¦¨²v¼úª÷­pºâ

[µo°Ý] ¹F¦¨²v¼úª÷­pºâ

½Ð°ÝªþÀɪº¹F¦¨¼úª÷¦p¦ó³]©w¤½¦¡¡A¨C¦¸¤À¬q­pºâ¦³ÂI®ö¶O®É¶¡¡AÁÂÁ¡C

¹F¦¨¼úª÷.zip (7.58 KB)

=LOOKUP(E4,{0,40,70,80,90,100},{0,4,8,11,14,17}*1000)*MIN(C44)*MAX(1,MIN(1.1,E4%))+MAX(0,(D4-C4*1.1)*20000)+MAX(0,(D4-C4*1.1-1)*2000)

0~40% ¥¼©w¸q ?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-4-10 12:06 ½s¿è

¦^´_ 9# shootingstar
¸Õ¸Õ¬Ý
F4Àx¦s®æ¤º®eÂŦr7§ï¦¨¬õ¦r³¡¤À6
=IF((100*D4/C4)<=70,D4*4000,IF(AND((100*D4/C4)>110,(D4-C4*1.1)<=1),C4*1.1*17000+(D4-C4*1.1)*20000,IF(AND((100*D4/C4)>110,(D4-C4*1.1)>1),C4*1.1*17000+20000+(D4-C4*1.1-1)*22000,HLOOKUP(MROUND(100*D4/C4,20),$L$7:$O$8,3,0)*D4)))

§ï¦¨
=IF((100*D4/C4)<=70,D4*4000,IF(AND((100*D4/C4)>110,(D4-C4*1.1)<=1),C4*1.1*17000+(D4-C4*1.1)*20000,IF(AND((100*D4/C4)>110,(D4-C4*1.1)>1),C4*1.1*17000+20000+(D4-C4*1.1-1)*22000,HLOOKUP(MROUND(100*D4/C4,20),$L$6:$O$8,3,0)*D4)))

TOP

¦^´_ 7# p212


    ³Â·ÐP212À°¦£¬Ý¤@¤U¡A¬°¦ó¦b³o±iªíªº¥Ø¼Ð4¡A¹ê»Ú3¡A¹F¦¨²v¬O75ªº®É­Ôºâ¤£¥X¨Ó¡H¥i¬O¦b§Aªº­ì©l«o¤S¨S°ÝÃD¡H

¼úª÷.zip (19.55 KB)

TOP

¦^´_ 7# p212


    ÁÂÁÂP212ªº¦^µª¡A¸Õ¥Î´X­Ó¨Ò¤l³£¦³¹F¨ì»Ý¨D¡AÁÂÁ¡C

TOP

¦^´_ 5# shootingstar
­«·s¤W¶ÇÀɮסA½Ð¸Õ¸Õ¬Ý¡I

¹F¦¨¼úª÷.zip (7.79 KB)

TOP

¦^´_  p212

±z¦n
§Ú¤U¸ü¸ÑÀ£ÁY¤§«á¡A·|¥X²{³o¼Ëªº¿ù©ö°T®§£°
shootingstar µoªí©ó 2013-3-31 22:56

ÀɦW§t¦³¤¤¤å¡A½Ð§ï¨Ï¥Î Winrar.exe ¸ÑÀ£§Y¥i¡A Winzip.exe ¹ï©ó¤¤¤å¡B¤é¤åµ¥¦r½XµLªk¿ëÃÑ¡C

TOP

¦^´_ 4# p212

±z¦n
§Ú¤U¸ü¸ÑÀ£ÁY¤§«á¡A·|¥X²{³o¼Ëªº¿ù©ö°T®§£°

¿ù»~°T®§.JPG (35.84 KB)

¿ù»~°T®§.JPG

TOP

¦^´_ 3# shootingstar
½Ð¸Õ¸Õ¬Ý¡A¦X¤£¦X§A­nªº¡C

¹F¦¨¼úª÷.xlsx.zip (8.35 KB)

TOP

¦^´_ 2# p212
¥H¹F¦¨²v­pºâµo©ñ¼úª÷¡A¦pªG¹F¦¨²v¸¨¦b40%~70%¡A¤@¥x¥iµo©ñ4000¤¸ªº¼úª÷¡A¥H¦¹Ãþ±À¡C
¥H¥Ø¼Ð5¥x¡A¹ê»Ú¹F¦¨6¥x¡A¹F¦¨²v¬°120%¡A¤À¬ÉÂI¬°110%¡A¨º»ò´N¬O5.5¥xªº¹F¦¨²v¬°110%¡A®t¹L110%ªº³¡¤À¡A²Ä¤@¥xµo20000¡A©Ò¥H³o­Ó¨Ò¤lªº¼úª÷¬°=5.5*17000+0.5*20000=103500
¥H¥Ø¼Ð4¥x¡A¹ê»Ú¹F¦¨2¥x¡A¹F¦¨²v¬°50%¡A©Ò¥H¹F¦¨¼úª÷=2*4000=8000
¥H¥Ø¼Ð4¥x¡A®É±H¹F¦¨7¥x¡A¹F¦¨²v¬°175%¡A¤À¬ÉÂIÁÙ¬O110%¡A¨º»ò4.4¥xªº¹F¦¨²v´N¬O110%¡A©Ò¥H¹F¦¨¼úª÷=4.4*17000+20000+(7-4.4-1)*22000=130000
¤£ª¾¹D³o¼Ëªº»¡©ú¦³¨S¦³¤ñ¸û²M·¡¡AÁÂÁ¡C

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD