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

[µo°Ý] ¦p¦ó¥Îif¨ç¼Æ¨Ó³]¥ß¦h­«±ø¥ó?

[µo°Ý] ¦p¦ó¥Îif¨ç¼Æ¨Ó³]¥ß¦h­«±ø¥ó?

¦p¹Ï¤ù:¦p¦ó¦bD2¨ìD8¥Îif¨ç¼Æ¡A±NÄæA.ÄæB¤ÎÄæcªº±ø¥ó±a¤J?

001.jpg (43.78 KB)

001.jpg

¦^´_ 1# dr.step
½Ð¸Õ¸Õ¬Ý¡A¤U¦C¤½¦¡¬O¤£¬O±z­nªºµ²ªG¡H
D2Àx¦s®æ¿é¤J
=IF(AND(A2="¨k",B2>70000,C2>180),"A+",IF(AND(A2="¨k",AND(B2<=70000,B2>50000),AND(C2<=180,C2>170)),"B+",IF(AND(A2="¤k",B2>60000,C2>170),"A-",IF(AND(A2="¤k",AND(B2<=60000,B2>40000),AND(C2<=170,C2>160)),"B","C"))))

TOP

¦^´_ 1# dr.step

D5¬OC¨º¬°¤°»òD6¬OB+©O?
¦p¹Ï¡A«hD2¤½¦¡
=CHOOSE(INT(IF(A2="¤k",(B2>40000)+(C2>160)+(B2>60000)+(C2>170),(B2>50000)+(C2>170)+(B2>70000)+(C2>180))/2)+1,"C",IF(A2="¤k","B","B+"),IF(A2="¤k","A-","A+"))

¬¡­¶Ã¯1.rar (3.82 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# Hsieh

¬Û¦PºÃ´b
¦³ÂI¬Ý¤£À´ÅÞ¿è
¥E¬Ý¤§¤U¬O­n²Å©MF,G,HÄ檺±ø¥ó¡A¨ú³Ì°ªªº
¹³¬O²Ä2¦C¡G¤k¡A22000¡A161¡A¥u²Å©M>160¡A¨Ã¤£²Å¦X>40000¡A¦]¦¹¬OC(¦Ó«DB)
¦ý¬O²Ä6¦C¡G¨k¡A66000¡A167¡A¥u²Å©M>50000¡A¨Ã¤£²Å¦X>170ÁÙ¬O±oB+(¦Ó«DC)

¦pªG¬O¬O­n²Å©MF,G,HÄ檺±ø¥ó¡A¨ú³Ì°ªªº¡G
D2{=IFERROR(INDEX($I$2:$I$5,MATCH(1,COUNTIF(A2,$F$2:$F$5)*COUNTIF(B2,$G$2:$G$5)*COUNTIF(C2,$H$2:$H$5),0)),$I$6)}¤U©Ô

TOP

¤p§Ì¤]¦P¼Ëªº¦³¤£¸Ñ,1¼Óªº¹Ï²Ä6¦C·Ó»¡À³¸Ó¬OC¦Ó«DB+,¬O§_Áä¿ù©Î¨ä¥¦­ì¦],¤£¹L¤T¦ì«e½ú¤TºØ¤½¦¡¼gªk,¯u¬O¾Ç¨ì¤F!!

TOP

°ÝÃD±ø¥ó¦³»~

²Ä2¦C¡GÀ³¸Ó¬OC (¦Ó«DB)
²Ä6¦C¡GÀ³¸Ó¬OB+(¦Ó«DC)
ss

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD