Excel表格中有数据a+b+c+d=f,如何使a,b,c,d等比例缩小,求和等于g答:将A1数据等比例缩小2倍,B1公式:=TEXTJOIN("+",,FILTERXML(""&SUBSTITUTE(LEFT(A1,FIND("=",A1)-1),"+","")&"","//b")/2)&"="&SUM(FILTERXML(""&SUBSTITUTE(LEFT(A1,FIND("=",A1)-1),"+","")&"","//b")/2)数组公式,按组合键CTRL+SHIFT+回车,完成公式;如果,将A1中...