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

来源：学生作业学帮网编辑：学帮网时间：2024/07/06 23:51:07

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

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