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

加入日期: Mar 2004
文章: 4,213
[求助] 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

一生卜卦 缺財想錢


https://www.youtube.com/shorts/KFfiN9HM12s



床舖前我的白月光已經剶光了,可愛的小蒂蒂像是上霜似的晶瑩剔透。
舉起小頭望向我的白月光,低下小頭進入生養的地方去探索。



吸個奶汁, 舔啊....猥瑣慾為
舊 2024-05-21, 10:50 PM #1
回應時引用此文章
polar168離線中