免费问答

比如这个:=IF(E27="经理",IF(V27/SUMIFS(业绩表!AB:AB,业绩表!Z:Z,B27,业绩表!AA:AA,C27)>=140%,IF(A27="C",14%,IF(A27="校园",14%,13%)),IF(V27/SUMIFS(业绩表!AB:AB,业绩表!Z:Z,B27,业绩表!AA:AA,C27)>=130%,IF(A27="C",14%,IF(A27="校园",14%,12%)),IF(V27/SUMIFS(业绩表!AB:AB,业绩表!Z:Z,B27,业绩表!AA:AA,C27)>=120%,IF(A27="C",13%,IF(A27="校园",13%,12%)),IF(V27/SUMIFS(业绩表!AB:AB,业绩表!Z:Z,B27,业绩表!AA:AA,C27)>=110%,IF(A27="C",12%,IF(A27="校园",12%,11%)),10%)))),IF(D27="新人",10%,IF(D27="初级",IF(S27>=20000,IF(A27="C",11%,IF(A27="校园",11%,10%)),IF(S27>=15000,IF(A27="A",8%,IF(A27="B",9%,10%)),IF(S27>=10000,IF(A27="A",7%,IF(A27="B",8%,9%)),IF(A27="A",6%,IF(A27="B",7%,8%))))),IF(D27="中级",IF(S27>=IF(A27="A",40000,30000),IF(A27="A",11%,IF(A27="B",11%,12%)),IF(S27>=IF(A27="A",30000,IF(A27="B",25000,20000)),IF(A27="A",11%,IF(A27="B",10%,11%)),IF(S27>=IF(A27="A",20000,IF(A27="B",20000,15000)),IF(A27="A",10%,IF(A27="B",9%,10%)),IF(A27="A",7%,IF(A27="B",8%,9%))))),IF(D27="高级",IF(S27>=IF(A27="A",50000,IF(A27="B",50000,40000)),IF(A27="A",12%,IF(A27="B",12%,13%)),IF(S27>=IF(A27="A",40000,30000),IF(A27="A",11%,IF(A27="B",11%,12%)),IF(S27>=IF(A27="A",30000,25000),IF(A27="A",10%,IF(A27="B",10%,11%)),IF(A27="A",8%,9%)))),IF(D27="核心",IF(S27>=IF(A27="A",70000,IF(A27="B",60000,50000)),IF(A27="A",13%,IF(A27="B",13%,14%)),IF(S27>=IF(A27="A",60000,IF(A27="B",50000,45000)),IF(A27="A",12%,IF(A27="B",12%,13%)),IF(S27>=IF(A27="A",50000,IF(A27="B",40000,35000)),IF(A27="A",11%,IF(A27="B",11%,12%)),IF(A27="A",9%,10%)))),IF(E27="代培经理",IF(S27>=IF(A27="A",70000,IF(A27="B",60000,50000)),IF(A27="A",13%,IF(A27="B",13%,14%)),IF(S27>=IF(A27="A",60000,IF(A27="B",50000,45000)),IF(A27="A",12%,IF(A27="B",12%,13%)),IF(S27>=IF(A27="A",50000,IF(A27="B",40000,35000)),IF(A27="A",11%,IF(A27="B",11%,12%)),IF(A27="A",9%,10%)))),0)))))))

您好，您发的公式，没有结合具体图片数据，没法给出结论