excel公式简化下=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SUM(B310,C310,D315,E33,F33,G33))有新的函数公式简化下.只会用基础的.

来源：学生作业帮助网编辑：作业帮时间：2024/05/09 05:36:34

excel公式简化下=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SUM(B3*10,C3*10,D3*15,E3*3,F3*3,G3*3))有新的函数公式简化下.只会用基础的.
excel公式简化下
=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SUM(B3*10,C3*10,D3*15,E3*3,F3*3,G3*3))
有新的函数公式简化下.只会用基础的.

excel公式简化下=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SUM(B3*10,C3*10,D3*15,E3*3,F3*3,G3*3))有新的函数公式简化下.只会用基础的.
=IF(COUNTBLANK(B3:G3)=6,"",SUMPRODUCT(B3:G3,{10,10,15,3,3,3}))