作者:乔山办公网日期:
返回目录:excel表格制作
你多加了一个抄括号,这样就正确袭了
=IF(OR(A5=1,A5=5),"1",IF(A5=3,"需人百工添加",IF(OR(I5="暂无度评分",J5="暂无评论"),"暂时无问法确定系数",IF(I5<=9.2,"0",IF(AND(9.2<I5,I5<=9.5),"0.5",IF(AND(9.5<I5,I5<9.8),"1",IF(AND(I5>=9.8,J5<1000),"1",IF(AND(1000<=J5,J5<2000,I5>=9.8),"1.5",IF(AND(J5>=2000,I5>=9.8),"2","无对答应系数")))))))))
=IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀道",IF(OR(C14<60,D14<60,E14<60,F14<60),"差专","及格属"))
=IF(OR(C14<60,D14<60,E14<60,F14<60),"差",IF(AND(C14>=80,D14>=80,E14>=80,F14>=80),"优秀","及格"))
=IF(COUNTIF(C14:F14,">=80")=4,"优秀",IF(COUNTIF(C14:F14,"<60"),"差","及格"))
EXCEL 中的OR,AND
OR(判断抄1,判断2,判断3...)
AND (判断1,判断2,判断3...)
还有一个小方法:zhidao
=index( {0,200,400,800},1+(F5>=D5)+(E5>=C5)+(H5>=G5))