数组公式为:
=TEXTJOIN("、",,TEXT(D2:H2/C2,"0.00%"))
ctrl+shift+enter产生花括号。
如图所示:
I2输入=TEXT(D2/C2,"00%")&"、"&TEXT(E2/C2,"00%")&"、"&TEXT(F2/C2,"00%")&"、"&TEXT(G2/C2,"00%")&"、"&TEXT(H2/C2,"00%")