Question

如果利用表格函数,来判断多个单元格的数值,并给个结果?

如果利用表格函数,来判断多个单元格的数值,并给个结果? 比如A的标准值为1%，B的标准值为2%，C的标准值为3%，D的标准值为4% 单元格数值 A是1.5% B是1% C是3.8% D是4% 判断过程 如果单元格数值大于等于标准，显示结果，完美！ 如果单元格A小于标准值并且其它几项都是大于等于标准值，那么就显示结果，A低于标准值 如果单元格B小于标准值并且其它几项都是大于等于标准值，那么就显示结果，B低于标准值 。。。。以此类推荐，这个用表格的函数，可以实现吗？大神们来看看

Answer 1

如图：G2：G5输入指标

H2=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("ABCD",IF(G2>=1%,"A",""),""),IF(G3>=2%,"B",""),""),IF(G4>=3%,"C",""),""),IF(G5>=4%,"D",""),"")&IF(LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("ABCD",IF(G2>=1%,"A",""),""),IF(G3>=2%,"B",""),""),IF(G4>=3%,"C",""),""),IF(G5>=4%,"D",""),""))=0,"完美","低于标准值")

或H2=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("ABCD",IF(G2>=1%,"A",""),""),IF(G3>=2%,"B",""),""),IF(G4>=3%,"C",""),""),IF(G5>=4%,"D",""),"")&IF(SUM(--TEXT(G2:G5-{1;2;3;4}%,"!0;!1;!0")),"低于标准值","完美")

数组公式