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

[µo°Ý] ¦p¦ó­pºâ­Ó§O¾Ç¥Í¦¨ÁZ¦b¥þÅé¾Ç¥Íªº¦Ê¤À¤ñ¡A¨Ã´«ºâ¦¨µ¥¯Å¤À¼Æ

[µo°Ý] ¦p¦ó­pºâ­Ó§O¾Ç¥Í¦¨ÁZ¦b¥þÅé¾Ç¥Íªº¦Ê¤À¤ñ¡A¨Ã´«ºâ¦¨µ¥¯Å¤À¼Æ

½Ð°Ý¦U¦ì¥ý¶i¡Ad2Àx¦s®æ­n«ç»ò¤U¨ç¼Æ©O¡H

¤À¼Æ¦b¥þÅé¾Ç¥Í80%¥H¤Wªº¤H¦¨ÁZ¬°5
¤À¼Æ¦b¥þÅé¾Ç¥Í60%~80%ªº¤H¦¨ÁZ¬°4
¤À¼Æ¦b¥þÅé¾Ç¥Í40%~60%ªº¤H¦¨ÁZ¬°3
¤À¼Æ¦b¥þÅé¾Ç¥Í20%~40%ªº¤H¦¨ÁZ¬°2
¤À¼Æ¦b¥þÅé¾Ç¥Í§C©ó20%ªº¤H¦¨ÁZ¬°1

Book2.rar (2.05 KB)

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

¦^´_ 1# ymes
=LOOKUP(C2,{0,20,40,60,80},{1,2,3,4,5})
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  ymes
=LOOKUP(C2,{0,20,40,60,80},{1,2,3,4,5})
Hsieh µoªí©ó 2013-7-24 22:53


§Ú¥¢±Ñ¤F¡K¡K
§Q¥Î¤j¤j°µ¥Xªºµ²ªG¡A¤À¼Æ¥u¦³4©M5¡A¨S¦³§Ú­nªºµ²ªG

­è­è¬ã¨s¥X=PERCENTRANK($C$2:$C$33,C2)¡A¦A§Q¥ÎIF¨Ó¤Àµ¥¯Å¤À¼Æ¡A
¦ý¸ê®Æ²³¦h¡A¯uªº«Ü¤£¤è«K¡A
·Q¦A¦¸½Ð°Ý¤j¤j¡A¤£¬Oª½±µ¶K¤W´N¯àÅã¥Ü¸Ó¦³ªºµ¥¯Å¶Ü¡H
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 3# ymes

play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 3# ymes


    ¥i¥H¥ÎPERCENTRANKªº¸Ü´N¤ñ¸û²³æ¤F

FÄæ¥ÎPERCENTRANKºâ¥X¶¥¬q¤À¼Æ,
¦¨ÁZÄæ¥ÎVLOOKUP§ä¥X

twbts20130724percentrank.zip (8.8 KB)

À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 4# Hsieh

¥i¯à¬O§Ú¥æ¥N¤£²M¡A¦¨ÁZµ¥²Ä³¡¥÷À³¸Ó¬O1¤À¨ì5¤À¥­§¡¤À§G¡A¦Ó«D¶°¤¤©ó4©M5¤À
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¦^´_ 5# kimbal

·PÁ§iª¾¡A¦ý§Ú¦³60µ§¸ê®Æ­n°µ¡A¥ý¬Ý¬Ý¦³¨S¦³§ó¤è«Kªº¤è¦¡¡A¨S¦³ªº¸Ü¡A¦A¥Î¤j¤jªº¤èªk¡A·PÁ±z¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-7-25 09:01 ½s¿è

¦^´_ 7# ymes
¬O¤£¬O¨Ï¥Î¦Ê¤À¦ì¼Æpercentile¨ç¼Æ¦A´«ºâ¦¨µ¥¯Å¤À¼Æ¸û¬°«ê·í¡H
½Ð°Ñ¦Ò
¦bD2Àx¦s®æ¿é¤J=IF(C2>=PERCENTILE(C:C,0.8),5,IF(AND(C2>=PERCENTILE(C:C,0.6),C2<PERCENTILE(C:C,0.8)),4,IF(AND(C2>=PERCENTILE(C:C,0.4),C2<PERCENTILE(C:C,0.6)),3,IF(AND(C2>=PERCENTILE(C:C,0.2),C2<PERCENTILE(C:C,0.4)),2,1))))
¦V¤U½Æ»s¤½¦¡

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-7-25 09:05 ½s¿è

¦^´_ 7# ymes
²Ä0¦Ê¤À¦ì­È¬°56.81, ²Ä10¦Ê¤À¦ì­È¬°71.18, ²Ä20¦Ê¤À¦ì­È¬°75.84, ²Ä40¦Ê¤À¦ì­È¬°83.87, ²Ä60¦Ê¤À¦ì­È¬°88.78, ²Ä80¦Ê¤À¦ì­È¬°92.33, ²Ä100¦Ê¤À¦ì­È¬°96.2

TOP

¦^´_ 1# ymes


    §Aªº´£°ÝÀ³¸Ó¬O­n»¡

¾Ç¥Í¦¨ÁZ¸Ì­±¡A¨Ì¾Ú¦¨ÁZ¡A©w¥X¤­­Ó¼h¯Å½d³ò  

¨C­Ó½d³òµ¹¤@­Ó¥N½X¡A¬Ý³o¨Ç¾Ç¥Í¤À§O¦b­þ­Ó¼h¯Å¸Ì­±¡A³o¼Ë¤l¤~¬O§Aªº·N«ä§a?

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD