早教吧作业答案频道 -->其他-->
excel中公示的问题.=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=1,ISERROR(FIND("",A3)),COUNTIF(A:A,A3)=1),"正确",IF(A3"",IF(NOT(ISERROR(FIND("",A3))),"有空格",IF(COUNTI
题目详情
excel中公示的问题.
=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=1,ISERROR(FIND(" ",A3)),COUNTIF(A:A,A3)=1),"正确",IF(A3"",IF(NOT(ISERROR(FIND(" ",A3))),"有空格",IF(COUNTIF(A:A,A3)>1,"重建",COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=0,"指标错误")),"")) 我按回车的时候总是“LEN”这个单词出问题,但我不知道怎么改,
=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=1,ISERROR(FIND(" ",A3)),COUNTIF(A:A,A3)=1),"正确",IF(A3"",IF(NOT(ISERROR(FIND(" ",A3))),"有空格",IF(COUNTIF(A:A,A3)>1,"重建",COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=0,"指标错误")),"")) 我按回车的时候总是“LEN”这个单词出问题,但我不知道怎么改,
▼优质解答
答案和解析
分式分
=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=1,ISERROR(FIND(" ",A3)),COUNTIF(A:A,A3)=1),"正确",【嵌套1】) 正确
【嵌套1】：
=IF(A3"","A",【嵌套2】) 正确
【嵌套2】：
=IF(NOT(ISERROR(FIND(" ",A3))),"有空格",【嵌套3】) 正确
【嵌套3】：
=IF(COUNTIF(A:A,A3)>1,"重建",【嵌套4】) 正确
【嵌套4】：
=COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=0,"指标错误" 错误
=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=1,ISERROR(FIND(" ",A3)),COUNTIF(A:A,A3)=1),"正确",【嵌套1】) 正确
【嵌套1】：
=IF(A3"","A",【嵌套2】) 正确
【嵌套2】：
=IF(NOT(ISERROR(FIND(" ",A3))),"有空格",【嵌套3】) 正确
【嵌套3】：
=IF(COUNTIF(A:A,A3)>1,"重建",【嵌套4】) 正确
【嵌套4】：
=COUNTIF(Sheet1!$A$2:$A$232,LEFT(A3,FIND("*",SUBSTITUTE(A3,":","*",LEN(A3)-LEN(SUBSTITUTE(A3,":",""))))-1))=0,"指标错误" 错误
看了excel中公示的问题.=IF...的网友还看了以下：
=IF(COUNTIF($B111:$G125,N$5)>=1,N$5,"") 2020-05-13 …
请问这个Excel公式中的2^8是什么意思?A13=INDEX(2:2,SMALL(IF((COU 2020-05-16 …
if公式,以下公式是啥意思,=IF(COUNTIF(I114,"*VISAONLY*"),IF(O 2020-06-02 …
如何简化以下IF公式,或突破7层嵌套的限制.=IF(COUNTIF(G3:AB11,"A")>0, 2020-06-02 …
=MOD($J3+AG3,10)=MOD($J3-$AC3,10)=MOD($J4-5,10)=I 2020-07-25 …
EXCEL公式疑问～=IF(ISERROR(IF(C7="A5大场",5000,SUM(OFFSET 2020-10-31 …
请问这两个删除重复的公式有什么不同?假设数据在A2-A11(A1为空）,我在B2编辑公式：=if（A 2020-11-01 …
EXCEL中,以下数组公式如何多增加一列进去?{=IF(AND(ISERROR(MATCH(1,(C 2020-11-01 …
excel中公示的问题.=IF(AND(COUNTIF(Sheet1!$A$2:$A$232,LEF 2020-11-01 …
能帮我简化下下面这条公式吗(同样是针对1——11数字组成的五个数的数组的）=IF(OR(produc 2020-11-07 …