EXCEL中将多个单元格内容合并到一个单元格并其中一项内容为空的则不显示

Question

上图为把各款项汇总到付款情况里边，但是没有（比如进度款）就不体现，这是我用的公式$E$2&E3&","&$F$2&F3&","&$G$2&G3&","&$H$2&H3&","&$I$2&I3+J3&","&$K$2&K3+L3&","&$M$2&M3&","&$N$2&N3&","&$O$2&O3，只是里边没用的也体现出来了，往高手指点

Answer 1

按你发来的表,公式:
=IF(D3="","",D$2&D3&",")&IF(E3="","",E$2&E3&",")&IF(F3="","",F$2&F3&",")&IF(G3="","",G$2&G3&",")&IF(H3="","",H$2&H3+I3&",")&IF(J3="","",J$2&J3+K3&",")&IF(L3="","",L$2&L3&",")&IF(M3="","",M$2&M3&",")&IF(N3="","",N$2&N3&",")&IF(O3="","",$O$2&O3)本回答被提问者采纳

Answer 2

设A1、B2、C3、A5、F6是要合并到A10的内容，请在A10输入公式：
=IF(or(isblank(A1),isblank(B2),isblank(C3),isblank(A5),isblank(F6)),"",A1&B2&C3&A5&F6)
公式中单元格内容请自行调整。追问

 

就是把上图各款项汇总到付款情况当中，我已经用公式了，但是里边没有款项的怎么能不让显示出来。下面这是我用的公式在付款情况中显示的。=$E$2&E3&","&$F$2&F3&","&$G$2&G3&","&$H$2&H3&","&$I$2&I3+J3&","&$K$2&K3+L3&","&$M$2&M3&","&$N$2&N3&","&$O$2&O3

Answer 3

你先手工画个Excel的表载下来。那样才好理解你的意图 。

Answer 4

使用if函数和字符相加&
具体根据你的格式而定