在EXCEL中某单元格里用IF条件语句一次能用几个IF,我的好像只能用8个...答:类似题目中,可以使用VLOOKUP达到类似的效果。举例:=VLOOKUP(L2,{5,"A";10,"B";15,"C";20,"D";25,"E";30,"F";35,"G";40,"H"},2,FALSE)如果L2不是上述的数时不显示数字,则可以 =IF(ISERROR(MATCH(L2,{5,10,15,20,25,30,35,40},0)),"",VLOOKUP(L2,{5,"A";10,"B"...
请教一下各位Excel函数的高手们用的IF函数答:=if(or(a1={28,36,59,65}),"上",if(or(a1={25,38,62,83}),"下",if(or(a1={13,35,49,53}),"左",if(or(a1={22,67,88,92}),"右","")))
execl里if函数公式 麻烦帮我看下哪里出错了?答:大于400的数它也肯定大于60啊对不对?)。你应该反过来,先处理大于等于400的(剩下的就都是小于400的),然后处理大于等于300的(剩下的就都是小于300的)……最后处理大于等于60的 =L11-IF(L11>=400,35,IF(L11>=300,25,IF(L11>=200,15,IF(L11>=100,10,IF(L11>=60,5,0)))...