Excel表格中有数据a+b+c+d=f,如何使a,b,c,d等比例缩小,求和等于g答:如图:将A1数据等比例缩小2倍,B1公式:=TEXTJOIN("+",,FILTERXML("<a><b>"&SUBSTITUTE(LEFT(A1,FIND("=",A1)-1),"+","</b><b>")&"</b></a>","//b")/2)&"="&SUM(FILTERXML("<a><b>"&SUBSTITUTE(LEFT(A1,FIND("=",A1)-1),"+","</b><b>")&"</b></a>","...