excel-day06

if函数和and,or函数

 

=IF(B2="理工","LG",IF(B2="文科","WK","CJ"))

=IF(E3="男","先生","女士")

=IF(G3="本地",H3+30)+IF(G3="本省",H3+20)+IF(G3="外省",H3+10)

=IF(I3>=600,"第一批",IF(I3>=400,"第二批","落榜"))

 

=IF(G6="A级",10000)+IF(G6="B级",9000)

 

 

 

=IF(ISERROR(D35/C35),0,D35/C35)

 

=IF(AND(B3>=60,A3="男"),1000,0)

 

 

=IF(OR(B12>=60,B12<40),1000,0)

 

=IF(OR(AND(B20>=60,A20="男"),AND(B20<=40,A20="女")),1000,0)