(一)IF函数
题目1:
=IF(B3="理工","LG",IF(B3="文科",”WK“,"CJ"))
题目2:判断成绩是一本、二本还是落榜
=IF(B7>600,"一本",IF(B7>400,"二本","落榜"))
note:如果需要判断的数目太多,可以使用累加的方式避免IF函数嵌套。例如=IF(B3="等级A",10000)+IF(B3="等级B",8000)+IF(B3="等级C",5000)
题目3:
=IF(ISERROR(D3/C3),0,D3/C3) //iserror是的话返回0,不是的话返回对应结果值
题目4: