å¨D3åå æ ¼è¾å ¥å ¬å¼ï¼
=IF(B3=0,"",IF(B3="女",LOOKUP(C3,{0,4.5,5.5,6.5,8},{"æå·®","ä¸åæ ¼","åæ ¼","è¯å¥½","ä¼ç§"}),LOOKUP(C3,{0,5,6,7,9},{"æå·®","ä¸åæ ¼","åæ ¼","è¯å¥½","ä¼ç§"})))
å¤å¶å¹¶ä¸æãï¼å ¶ä¸ï¼å¥³çæ绩为4.5以ä¸ã4.5-5.6ã5.5-6.5ã6.5-8å8以ä¸åå«ç»äºæå·®ãä¸åæ ¼ãåæ ¼ãè¯å¥½ãä¼ç§ç表述ï¼èç·ççä¸è¿°åºé´æ绩为ï¼5以ä¸ã5-6ã6-7ã7-9å9以ä¸ï¼
å¨F3åå æ ¼è¾å ¥å ¬å¼ï¼
=IF(B3=0,"",IF(B3="女",LOOKUP(E3,{0,3.4,3.8,4.4,4.8,5.4},{"ä¼ç§","è¯å¥½","åæ ¼","ä¸åæ ¼","æå·®"}),LOOKUP(E3,{0,3.2,3.6,4.2,4.6},{"ä¼ç§","è¯å¥½","åæ ¼","ä¸åæ ¼","æå·®"})))
å¤å¶å¹¶ä¸æã
ï¼å ¶ä¸ï¼å¥³çæ绩为5.4以ä¸ã4.8-5.4ã4.4-4.8ã3.8-4.4å3.8以ä¸åå«ç»äºæå·®ãä¸åæ ¼ãåæ ¼ãè¯å¥½ãä¼ç§ç表述ï¼èç·ççä¸è¿°åºé´æ绩为ï¼4.6以ä¸ã4.2-4.6ã3.6-4.2ã3.2-3.6å3.2以ä¸ï¼
å½ç¶ï¼ä½ ä¹å¯ä»¥æ大æ¬å·éçï¼{"ä¼ç§","è¯å¥½","åæ ¼","ä¸åæ ¼","æå·®"}
æ¹æ为ï¼{95ï¼80ï¼60ï¼50ï¼45}ï¼è¿æ ·åºæ¥å°±ç´æ¥æ¯æ°ååæ°äºã
ä¸é¢çåºåå段åå¾åæè¿°å¯ä»¥æ ¹æ®éè¦å¯¹å ¬å¼è¿è¡ä¿®è®¢è°æ´ã