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

¦h­«°²³]°ÝÃD

¦h­«°²³]°ÝÃD

¨ä¹ê§Ú¤]¤£¤Ó½T©w³o­Ó¼ÐÃD¬O§_¤Uªº¦n.§Ú·Q­n°µªº¬OÃÒ劵§ë¸êªº¦^ºÓ´ú¸Õ,¥Î§Q²v©M§Q®t¨â­Ó±ø¥ó¨Ó¨M©w§ë¸êªøµu¤Ñ´Áªº¤ñ­«
²³æªº»¡,¦³¨â­ÓÅܼÆA©MB, A¬°ªø劵§Q²v,B¬°ªøµu劵§Q®t,±ø¥ó¦p¤U
1.·íA¹F¨ì2.2(§t)¥H¤W,¥BB¬°0.3(§t)¥H¤W®É,«h100%§ëªø
2.·íA¹F¨ì2.2(§t)¥H¤W,¥BB¬°0.3¥H¤U®É,«h75%§ëªø,25%§ëµu
3.·íA¬°1.9(§t)~2.2¤¤¶¡,¥BB¬°0.3(§t)¥H¤W®É,«hªø/µu ¦U50%
4.·íA¬°1.9(§t)~2.2¤¤¶¡,¥BB¬°0.3¥H¤U®É,«hªø/µu 35%/65%
5.·íA¬°1.6(§t)~1.9¤¤¶¡,¥BB¬°0.3(§t)¥H¤W®É,«hªø/µu 20%/80%
6.·íA¬°1.6(§t)~1.9¤¤¶¡,¥BB¬°0.3¥H¤U®É,«hªø/µu 10%/90%
7.·íA¤p©ó1.6,«h100%§ëµu劵

ªøµu劵¤§¤ñ­«¥²¶·¤j©óµ¥©ó¹s,¥B¥²¶·§¹¥þ§ë¸ê

¨ä¹ê´N¬O­n§äªþ¥óHÄ檺¤ñ­«,IÄ檽±µ¥Î(1-H)§Y¥i

§Ú¥Ø«e°µªk¬O¥ý±N§Q²v¤Î§Q®t¦U³]©w¤@KEY­È,¦pÄæ¦ìE©MF
EÄæ¦ì§Q²vªºKEY­È,§Q²v >=2.20«h¬°3. 1.9<=§Q²v<2.2,«h¬°2. 1.6<=§Q²v<1.9,«h¬°1. §Q²v<1.6«h¬°0
FÄæºû§Q®tKEY­È. §Q®t>=0.3,«h¬°1,§_«h¬°0
®Ú¾Ú¤W­±±ø¥ó§@¤@²³æ¤§ªí®æ(K13:M17). ®Ú¾ÚKEY­È©Ò§ä¥Xªº¼Æ¦r¥hvlookupªí®æ²zªº²Õ¦X±ø¥ó±o¨ì§ë¸ê¤ñ­«....

§Ú·Q½Ð±Ð¦U¦ì«e½ú¬O§_¦³§ó®e©öªº°µªk,¯à°÷¹F¨ì©Ò­nªº§ë¸ê¤ñ­«,¤S¯à²¤Æ¾ã­Óexcelªº¨Ï¥Î,¸`¬Ù¤@ÂI®É¶¡. ·P¿E¤£ºÉ

Book2.rar (10.96 KB)

Jeffrey Chen

­ì¨Ólookup¥i¥H³o¼Ë¥Î,ÁÂÁ«ü¾É
Jeffrey Chen

TOP

I5=LOOKUP(B5,{0,1.6,1.9,2.2},IF(D5<0.3,{0,10,35,75},{0,20,50,100}))/100
H5=1-I5
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD