在空白格内输入=IF(SUM(G1+H1+I1+J1)>1200,1200,SUM(G1+H1+I1+J1))
=if(sum(g1:j1)>1200,1200,sum(g1:j1))
=min(1200,sum(G1:J1))
=min(SUM(G1+H1+I1+J1),1200)其他情况自己举一反三
=IF(SUM(G1+H1+I1+J1)>1200,1200,SUM(G1+H1+I1+J1))
