00:10:00
問題已解決
if函數多個嵌套，比如計算提成比例的時候，先按職位，再按每個職位的完成比。每個if函數結尾幾個括號總是搞不清楚。請問有沒有什么規律可循
溫馨提示：如果以上題目與您遇到的情況不符，可直接提問，隨時問隨時答
您好，這個就是要具體分析
2022 06/25 16:24
84785038 
2022 06/25 16:29
比如這個:=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)))))))
小林老師 
2022 06/25 21:00
您好，您發的公式，沒有結合具體圖片數據，沒法給出結論
閱讀 866
描述你的問題，直接向老師提問
1114
意見反饋
