Board logo

標題: if超過多個應如何歸納 [打印本頁]
作者: jim    時間: 2014-9-7 11:25     標題: if超過多個應如何歸納

請教各位前輩 在儲存格內
  =if(fy7=1,sum(t7:ab7),if(fy7=2,sum(u7:ab7,k7),if(fy7=3,sum(v7:ab7,k7:l7),if(fy7=4,sum(w7:ab7,k7:m7)if(fy7=5,sum(x7:ab7,k7:n7)
  if(fy7=6,sum(y7:ab7,k7:o7),xxx)&if(fy7=7,sum(z7:ab7,k7:p7),if(fy7=8,sum(aa7:ab7,k7:q7),if(fy7=9,sum(ab7,k7:r7),if(fy7=10,sum(k7:s7),yyy)
    xxx = 應如何填寫      yyy= 應如何填寫
或是有更好涵數可代替請賜教 謝謝
作者: ML089    時間: 2014-9-7 22:47

使用CHOOSE函數
作者: luhpro    時間: 2014-9-9 00:01

本帖最後由 luhpro 於 2014-9-9 00:11 編輯
請教各位前輩 在儲存格內
  =if(fy7=1,sum(t7:ab7),if(fy7=2,sum(u7:ab7,k7),if(fy7=3,sum(v7:ab7,k7:l7), ...
jim 發表於 2014-9-7 11:25

你的公式左右括弧數量不相等,
這樣不能確定該如何改公式.
作者: jim    時間: 2014-9-9 05:58

回復 3# luhpro

請教各位前輩 在儲存格內
  =if(fy7=1,sum(t7:ab7),if(fy7=2,sum(u7:ab7,k7),if(fy7=3,sum(v7:ab7,k7:l7),if(fy7=4,sum(w7:ab7,k7:m7),if(fy7=5,sum(x7:ab7,k7:n7),
  if(fy7=6,sum(y7:ab7,k7:o7),xxx))))))&if(fy7=7,sum(z7:ab7,k7:p7),if(fy7=8,sum(aa7:ab7,k7:q7),if(fy7=9,sum(ab7,k7:r7),if(fy7=10,sum(k7:s7),yyy))))
    xxx = 應如何填寫      yyy= 應如何填寫
或是有更好涵數可代替請賜教 謝謝



歡迎光臨 麻辣家族討論版版 (http://forum.twbts.com/)