word 求成绩结果计算公式

2014-10-29 00:00:00 by 【6yang】, 787 visits, 收藏 | 返回

求算成绩：
=IF(AND(F9>=70,F9<=75),"优秀",IF(AND(45<=F9),"及格","不及格"))

了解AVERAGE，　SUMIF，　AND,　