瀏覽單個文章
polar168
Elite Member
 
polar168的大頭照
 

加入日期: Mar 2004
文章: 4,207
[求助] EXCEL的IF函數

強者我朋友問我.....但我也是EXCEL低手

=ROUND(IF(AND(AND(E3>=80%,I3>=80%),J3>=N3),E3*(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3)))))),IF(AND(AND(E3>=60%,I3>=80%),J3>=N3),E3*$K$1*(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3))))))),IF(AND(AND(E3>=80%,I3>=80%),((H3*J3)/(G3*N3))>=$N$1),(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3))))))*$K$1*(H3*J3)/(G3*N3)),IF(AND(AND(E3>=60%,I3>=80%),((H3*J3)/(G3*N3)>=$N$1)),$K$1*E3*((H3*J3)/(G3*N3))*(IF($G$1="Q1",(ad3),IF($G$1="Q2",(ae3),IF($G$1="Q3",(af3),IF($G$1="Q4",(ag3)))))))),0)



朋友說, EXCEL裡回應 "您己輸入此函數的太多引數"

請問有高手會嗎?
     
      
__________________
https://pcdvd.com.tw/showpost.php?p=1087489044&postcount=7

一生卜卦 缺財想錢
舊 2024-05-21, 10:50 PM #1
回應時引用此文章
polar168離線中