Excel 逻辑判断 IF,SWITCH,容错,IFS,嵌套IF

简单IF判断 =IF(D60>70,“买不起”,“有能力”)

=IF(D60>70,"买不起","有能力")

IF函数嵌套公式 =IF(E60=“已签收”,“完成”,IF(E60=“待签收”,“完成”,“途中”))

=IF(E60="已签收","完成",IF(E60="待签收","完成","途中"))

参考：IF 函数 - 嵌套公式和避免错误

SWITCH =SWITCH(G60,“北方”,“north”,“南方”,“south”)

=SWITCH(G60,"北方","north","南方","south")

---

根据成绩范围判断成绩档 =IFS(D3=100,“满分”,D3>=95,“优秀”,D3>=85,“良好”,D3>=70,“较好”,D3>=60,“及格”,D3<60,“不及格”)

=IFS(D3=100,"满分",D3>=95,"优秀",D3>=85,"良好",D3>=70,"较好",D3>=60,"及格",D3<60,"不及格")

参考：多条件判断

---

容错 =IFNA(XXXXXX,“N/A”)，=IFERROR(XXXXX,“Error”)

=IFNA(XXXXXX,"N/A")
=IFERROR(XXXXX,"Error")