EXCELå¦ä½ç»è®¡åæ°æ®µï¼
以ä¸æ们就以å¦çæ绩ç级é®é¢ä¸ºä¾ï¼æ¥è¯´ææ¯å¦ä½è¿è¡ç»è®¡çã
åå®ï¼æ绩大äºçäº90ç为Açï¼æ绩大äºçäº80å°äº90ç为Bçï¼æ绩大äºçäº70å°äº80ç为Cçï¼æ绩大äºçäº60å°äº70ç为Dçï¼æ绩å°äº60ç为Eçã
æ±è§£æ¥éª¤ï¼
1ãå建æ°ççµåææ¡£ï¼è¾å ¥åå¦ççæ绩ï¼ç¬¬ä¸å为å¦çå§åï¼ç¬¬äºå为æ绩ï¼ç¬¬ä¸å为æ绩ç级
2ãæ ¹æ®æ¡ä»¶ï¼å¨ç¬¬äºè¡ç¬¬ä¸åï¼è¾å
¥å¤æå½æ°ï¼å³
å¨ãC2åå æ ¼ãå¤ï¼è¾å ¥ fx=IF(AND(B2>=90,B2<=100),"A",IF(AND(B2>=80,B2<90),"B",IF(AND(B2>=70,B2<80),"C",IF(AND(B2>=60,B2<70),"D","E"))))
3ãè¾å ¥åç¡®å®ï¼å¹¶éä¸ãC2åå æ ¼ãï¼ç¹ä¸ãC2åå æ ¼ãå¤çå°ååï¼ä¸æ
4ãä¸æåï¼å°±å¾å°åå¦ççæ绩ç级ã