2021-06-09【Excel】拼接格式

二维数组

=
"["&
IF('#value'!I4>0, "["&'#value'!I4&","&'#value'!J4&","&'#value'!K4&"]","")
&
IF('#value'!L4>0, ",["&'#value'!L4&","&'#value'!M4&","&'#value'!N4&"]","")
&
IF('#value'!O4>0, ",["&'#value'!O4&","&'#value'!P4&","&'#value'!Q4&"]","")
&
IF('#value'!R4>0, ",["&'#value'!R4&","&'#value'!S4&","&'#value'!T4&"]","")
&
IF('#value'!U4>0, "|"&'#value'!U4&","&'#value'!V4&","&'#value'!W4&"]","")
&"]"

字典表

=
IF(OR('#Sheet2'!O4>0,'#Sheet2'!P4>0),"{","")
&
IF('#Sheet2'!O4>0,'#Sheet2'!O4,"")&IF(AND('#Sheet2'!O4>0,'#Sheet2'!P4>0),",","")&IF('#Sheet2'!P4>0,'#Sheet2'!P4,"")
&
IF(OR('#Sheet2'!O4>0,'#Sheet2'!P4>0),"}","")

定义变量

如何避免损坏的公式 - Office 支持 (microsoft.com)