excel公式简化下=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SU

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/22 01:42:46

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}))