word 求成绩结果计算公式

2014-10-29 00:00:00 by 【6yang】, 361 visits, 收藏 | 返回
求算成绩:
=IF(AND(F9>=70,F9<=75),"优秀",IF(AND(45<=F9),"及格","不及格"))


了解AVERAGE, SUMIF, AND, 
分享到:
share

    图片原图

    loading

    loading