Excel公式错误.=IF(A2="郭鹏",B3,IF(A2="彭辉",1.5%,IF(A2="卜珊珊",2%,IF(A

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/09/27 12:14:05

Excel公式错误.
=IF(A2="郭鹏",B3,IF(A2="彭辉",1.5%,IF(A2="卜珊珊",2%,IF(A2="胡彦军",B3,IF(A2="万利鲜",2%,IF(A2="张会军",B3,IF(A2="李哲",1.5%,IF(A2="张阳",2%,IF(A2="朱常
青",B3,IF(A2="王蕊",1.5%,IF(A2="谷超",B3,IF(A2="刘春普",1.5%,IF(A2="朱建省",B3,IF(A2="谷清",B3,IF(A2="侯继勇",1.2%,IF(A2="刘航",1.2%,IF(A2="董国
王",1.5%,IF(A2="张荣",1.2%,IF(A2="王薇",1.2%,IF(A2="孙大勇",1.5%,IF(A2="刘月华",1.5))))))))))))))))))))
实在检查不出来哪里错误了.

少了一层反括号.
再问：已经多加了一个了还是不行。
再答：如果你是2003版，公式不能超过7层嵌套。WPS表格的话，应新建.xlsx格式文档，才能支持超过7层的IF嵌套公式。
公式可改为：
=IF(OR(A2={"郭鹏","胡彦军","张会军","朱常青","谷超","朱建省","谷清"}),B3,IF(OR(A2={"彭辉","李哲","王蕊","刘春普","董国王","孙大勇","刘月华"}),1.5%,IF(OR(A2={"卜珊珊","万利鲜","张阳"}),2%,IF(OR(A2={"侯继勇","刘航","张荣","王薇"}),1.2%,""))))

Excel公式错误.=IF(A2="郭鹏",B3,IF(A2="彭辉",1.5%,IF(A2="卜珊珊",2%,IF(A excel中=IF(A2="","",IF(ISERROR(VLOOKUP(A2,SHEET1!A:B,2,0)),"查 =IF(A2>90,A ,IF(A2>80,B ,C )) excel 函数翻译B2=IF(COUNTIF($A$2:$A$100,A2)>1,A2,"") excel判断闰年=IF(A2/40,"平年",IF(A2/1000,"闰年",IF(A2/4000,"平年","闰年" excel中：如何实现=if(a2=d2,b2=e2,if(a3=d3,b3=d3,if(a4=d4,b4=e4,if( =IF(COUNTIF($A$1:A2,A2)>0,COUNTIF($A$1:A2,A2)) =IF(A2="","",VLOOKUP(A2,银行帐号,2,0)) 这个公式怎么不对?=IF(A270000,6%,IF(AND(A240000),5%,IF(A2 EXCEL中的这句：IF(A2A1,COUNTIF($A$2:$A$6,A2),"") 是什么运算?A2==A1? 这个EXCEL函数哪里不对?=IF(B2-A2>0,round("提高"&(B2-A2)/A2,2),"下降"&roun =IF(A215,(A2-15)*2+15,A2))这个公式怎么理解