免費問答

比如這個:=IF(E27="經(jīng)理",IF(V27/SUMIFS(業(yè)績表!AB:AB,業(yè)績表!Z:Z,B27,業(yè)績表!AA:AA,C27)>=140%,IF(A27="C",14%,IF(A27="校園",14%,13%)),IF(V27/SUMIFS(業(yè)績表!AB:AB,業(yè)績表!Z:Z,B27,業(yè)績表!AA:AA,C27)>=130%,IF(A27="C",14%,IF(A27="校園",14%,12%)),IF(V27/SUMIFS(業(yè)績表!AB:AB,業(yè)績表!Z:Z,B27,業(yè)績表!AA:AA,C27)>=120%,IF(A27="C",13%,IF(A27="校園",13%,12%)),IF(V27/SUMIFS(業(yè)績表!AB:AB,業(yè)績表!Z:Z,B27,業(yè)績表!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="代培經(jīng)理",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)))))))

您好，您發(fā)的公式，沒有結(jié)合具體圖片數(shù)據(jù)，沒法給出結(jié)論