標題: 請問這儲存格內函數可以簡化嗎? [打印本頁]

---

作者: jeffrey628litw    時間: 2019-12-21 11:20     標題: 請問這儲存格內函數可以簡化嗎?

請問這儲存格內函數可以簡化嗎?

I欄的公式可以簡化嗎?(因為只能用在2010以後的Excel 版本，2007不能寫以下那麼多的函數)

=IF(O2="GAA",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(Z2<>"",Z2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AE2<>"",AE2&" ","")&IF(W2<>"",W2&" ","")&IF(Y2<>"",Y2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),IF(O2="GAF",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(W2<>"",W2&" ","")&IF(X2<>"",X2&" ","")&IF(Y2<>"",Y2&" ","")&IF(Z2<>"",Z2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),IF(O2="GBE",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(X2<>"",X2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AC2<>"",AC2&" ","")&IF(W2<>"",W2&" ","")&IF(AE2<>"",AE2&" ","")&IF(Y2<>"",Y2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),IF(O2="GAE",IF(T2<>"",T2&" ","")&IF(U2="-","",U2&" ")&IF(V2<>"",V2&" ","")&IF(W2<>"",W2&" ","")&IF(Y2<>"",Y2&" ","")&IF(X2<>"",X2&" ","")&IF(AA2<>"",AA2&" ","")&IF(AB2<>"",AB2&" ","")&IF(AC2<>"",AC2&" ","")&IF(AD2<>"",AD2&" ","")&IF(AE2<>"",AE2&" ","")&IF(AG2<>"",RIGHT(AG2,2),"")&IF(AG2<>"","-","")&IF(AH2<>"",RIGHT(AH2,2),"")&IF(AI2="-","","("&AI2&")"),""))))

檔案下載：[attach]31567[/attach]

---

作者: hcm19522    時間: 2019-12-21 15:48

https://blog.xuite.net/hcm19522/twblog/588751754

---

作者: jeffrey628litw    時間: 2019-12-22 19:35

回復 2# hcm19522


    感謝大大的指導分享，完全符合我想要的。

---

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