哪位高手帮我把I2和J2的公式列出来,请教高手把I2和J2的公式列出来,

网友回答

I2：=IF(B2>8,8,B2)+IF(C2>8,8,C2)+IF(D2>8,8,D2)+IF(E2>8,8,E2)+IF(F2>8,8,F2)
J2：=SUM(B2:F2)-I2
或者=IF(B2>8,B2-8,0)+IF(C2>8,C2-8,0)+IF(D2>8,D2-8,0)+IF(E2>8,E2-8,0)+IF(F2>8,F2-8,0)