如何合并这三个if函数到一个单元格里面?答:直接改,用IF嵌套函数,最后为什么要显示为文本0呢,不显示为空?=IF(OR(ISNUMBER(FIND({"四川","陕西","北京","天津","山西","重庆","海南","云南","甘肃","宁夏","内蒙古","贵州","山东","河北"},C2))),"二区",IF(OR(ISNUMBER(FIND({"江苏","浙江",...
excel中if函数能输入几个嵌套呢??答:超过8个,是不可以用了。但至少有两种办法可以解决这个问题,这得看你的具体要求了。举例:=IF(A1="a","王五","")&IF(A1="b","张三","")&IF(A1="c","李四")可以继续&连接下去。或者:=INDEX({"张三","李四","王五","赵六","小三","不知道","唐骏","土摩托"},MATCH("b",{...
if函数多个条件返回不同的值公式设置?答:以下是一个示例,假设有一个成绩表格,根据不同的分数段返回不同的等级:AB 80A 70B 60C 50D 40E 30F 在单元格B1中输入以下公式:=IF(A1>=80, "A", IF(A1>=70, "B", IF(A1>=60, "C", IF(A1>=50, "D", IF(A1>=40, "E", “F”)))这个公式会根据A1单元格的值判断分数段...
Excel中的IF嵌套函数,谢谢帮忙!答:=IF(D4<0.6,0,IF(D4>=0.6,C4*0.02,IF((C4-B4)>=2000,C4*0.03,IF((C4-B4)>=3000,C4*0.04,IF((C4-B4)>=4000,C4*0.05,IF((C4-B4)>=5000,C4*0.06,)))