Excel if条件的嵌套函数超过10个该怎么写答:可以在逗号后直接留空,省略不写,也可以写0 。=IF(条件1,结果1,IF(条件2,结果2,IF(条件3,结果3,IF(条件4,结果4,)))=IF(条件1,结果1,IF(条件2,结果2,IF(条件3,结果3,IF(条件4,结果4,0)))。将已知数据建表,然后通过INDEX+MATCH函数查找引用数据。在E10单元格输入=INDEX($H$2:$U...
Excel中IF函数的嵌套用法 求等于0为A, 0~5位为B,6-10为C,10以上为D答:=IF(A1>10,"D",IF(A1>5,"C",IF(A1>0,"B","A")))或者:=IF(A1<1,"A",IF(A1<6,"B",IF(A1<11,"C","D")))如果不是一定要用IF函数的,用以下公式可精简一些:=LOOKUP(A1,{0,"A";1,"B";6,"C";11,"D"})
excel中if函数能输入几个嵌套呢??答:A1="b","张三","")&IF(A1="c","李四")可以继续&连接下去。或者:=INDEX({"张三","李四","王五","赵六","小三","不知道","唐骏","土摩托"},MATCH("b",{"a","b","c","d","e","f","g","h"},0))结果为”李四“,把粗体的b改为g,返回“唐骏";可以继续加很多。
电子表格中if函数怎么包含十种情况?答:=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10},{"我","们","的","爱","过","了","就","不","再","来"})