Q项分数,R填等第。<60不合格,>=60<75是合格,大于等于75小于85良,大于等于85是优,请问等第的公式怎么设置?
å设77å³è¾¹çåå
æ ¼ä¸R6ï¼åå¨R6ä¸è¾å
¥å
¬å¼ï¼
=IF(Q6<60,"ä¸åæ ¼",IF(Q6<75,"åæ ¼",IF(Q6<85,"è¯","ä¼")))
ä¸æå¤å¶
=IF(Q6<60,"ä¸åæ ¼",IF(Q6<75,"åæ ¼",IF(Q6<85,"è¯","ä¼")))
ä¸æå¤å¶
温馨提示:答案为网友推荐,仅供参考
第1个回答 2015-01-15
如果你要填的第一格是R5,那么
R5=IF(Q5>85,"优",if(Q5>=75,"良",if(Q5>=60,"合格","不合格")
下拉 搞定
R5=IF(Q5>85,"优",if(Q5>=75,"良",if(Q5>=60,"合格","不合格")
下拉 搞定
第2个回答 2015-01-15
=LOOKUP(D1,{0;60;75;85},{"不合格";"合格";"良";"优秀"})