一、使用IF函数
1、IF函数的基本用法
函数语法:IF(logical_test,[value_if_true],[value_if_false])
=IF(E2="男","先生","女士")
IF函数的嵌套:
=IF(B2="理工","LG",IF(B2="文科","WK","CJ"))
=IF(G7="本地",H7+30,IF(G7="本省",H7+20,H7+10))
=IF(I61>=600,"第一批",IF(I61>=400,"第二批","落榜"))
IF函数的串联:
=IF(G9="A级",10000,0)+IF(G9="B级",9000,0)+IF(G9="C级",8000,0)+IF(G9="D级",7000,0)
=IF(G21="A级","一级","")&IF(G21="B级","二级","")&IF(G21="C级","三级","")
用IF函数处理运算错误 Iserror函数:
=IF(ISERROR(D35/C35),0,D35/C35)
二、AND函数与OR函数
1、AND函数:表示“且”的关系
=IF(AND(A6="男",B6>=60),1000,0)
2、OR函数:表示“或”的关系
=IF(OR(B12>=60,B12<=40),1000,0)
=IF(OR(AND(A23="男",B23>=60),AND(A23="女",B23<=40)),1000,0)
转载于:https://blog.51cto.com/steins/1570933