要怎麼使用IF函數帶出有打勾的染料名稱(同時可能不只一種染料)? 結果像綠色欄位那樣?

<<參考檔>>下載地址


http://www.FunP.Net/619293

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,"")