excel的if函数多个嵌套答:LOOKUP(A1,{0,50,150,250,350,450,550,650,750},{4.5,5.6,6.7,7.6,8.6,9.6,10.6,11.6})第一个数组前需加0,否则50以内的数无法判断
excel中if函数能输入几个嵌套呢??答:A1="b","张三","")&IF(A1="c","李四")可以继续&连接下去。或者:=INDEX({"张三","李四","王五","赵六","小三","不知道","唐骏","土摩托"},MATCH("b",{"a","b","c","d","e","f","g","h"},0))结果为”李四“,把粗体的b改为g,返回“唐骏";可以继续加很多。
excel中if函数怎么用有多个条件,多个结果答:1、首先打开excel表格,输入学生姓名和成绩,设置等级列。2、接着在等级列中,输入条件语句=(IF(B2>=90,"优秀",IF(B2>=80,"良好",IF(B2>=70,"中等",IF(B2>=60,"及格",IF(B2<60,"不及格"))),回车得到等级结果。3、然后在第一个等级单元格右下角下拉填充公式。4、填充完成后,如下图...