要怎麼使用IF函數帶出有打勾的染料名稱(同時可能不只一種染料)? 結果像綠色欄位那樣?
回答 (2)
2017-08-25 10:09 am
2017-08-24 8:18 pm
E3=IF(B3="V",B$2,"")&IF(C3="V",C$2,"")&IF(D3="V",D$2,"")
或
E3=IF(B3="V",B$2,"")&IF(COUNTA(B3)*COUNTA(C3:D3),"、","")&IF(C3="V",C$2,"")&IF(COUNTA(B3:D3)=3,"、",IF(COUNTA(C3:D3)=2,"、",""))&IF(D3="V",D$2,"")
或
E3=IF(B3="V",B$2,"")&IF(COUNTA(B3)*COUNTA(C3:D3),"、","")&IF(C3="V",C$2,"")&IF(COUNTA(B3:D3)=3,"、",IF(COUNTA(C3:D3)=2,"、",""))&IF(D3="V",D$2,"")
收錄日期: 2021-04-28 17:41:38
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20170824094339AAkuo24