C是B/A得到的,C有多个值的时候就无法显示百分比格式,有什么办法能解决吗
这样?
=MAPARRAY(split("0.3423444,0.432344,0.4342322",","),FORMAT(item,"#0.00%"))
你这A 和B 有多值对吗?
FORMAT(b/a,"#0.00%")