求EXCEL简单公式,在线等,感谢!答:公式一如下:=IF(SUM(COUNTIF(B1,"*"&MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)&"*")),"D","")公式二如下:=IF(SUM(COUNTIF(B1,"*"&MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)&"*")),"","C")
excel中if超出7层要怎么办,x需要在12个区间内判断,每个区间对应的函数...答:2003版IF函数如果超出7个条件就无法实现,这是本身的限制。解决方法:1、使用自定义名称,自定义名称示例:=IF(A3=100,100,IF(A3=99,99,IF(A3=98,98,IF(A3=97,97,IF(A3=96,96,IF(A3=95,95,IF(A3=94,94,IF(A3=93,93,aa)))aa=IF(Sheet1!A2=92,92,IF(Sheet1!A2=91,91,IF(She...