=REPLACE(if(A5 >= 10 ^ 8, CONCATENATE(int(A5 / (10 ^ 8)) + "亿", int((A5 - int(A5 / (10 ^ 8)) * 10 ^ 8) / 10000), "万", A5 - (int(A5 / (10 ^ 8)) * 10 ^ 8) - (int((A5 - int(A5 / (10 ^ 8)) * 10 ^ 8) / 10000) * 10000), "元"), if(A5 >= 10 ^ 4, int(A5 / 10000) + "万" + (A5 - (int(A5 / 10000) * 10000)) + "元", A5 + "元")),"0元","")
公式形态的设置公式：
if($$$<=0,"","总共的金额为:")+"<span style='color:#de2c2c;font-size:16px;font-weight:bold'>" + REPLACE(if($$$ >= 10 ^ 8, CONCATENATE(int($$$ / (10 ^ 8)) + "亿", int(($$$ - int($$$ / (10 ^ 8)) * 10 ^ 8) / 10000), "万", $$$ - (int($$$ / (10 ^ 8)) * 10 ^ 8) - (int(($$$ - int($$$ / (10 ^ 8)) * 10 ^ 8) / 10000) * 10000), "元"), if($$$ >= 10 ^ 4, int($$$ / 10000) + "万" + ($$$ - (int($$$ / 10000) * 10000)) + "元", $$$ + "元")),"0元","") + "</span>"
1min目标场景问卷
立即参与
