作业帮excel公式简化下=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SUM(B3*10,C3*10,D3*15,E3*3,F3*3,G3*3))有新的函数公式简化下.只会用基础的.
来源：学生作业帮助网 编辑：作业帮 时间：2024/07/19 16:27:50
x)KHNyںL{MEVIILIW0&A Teh T "])P1P)pt>{M݀fUOz>e/l ӳI*@m\ 6 9?/hހ PN5r21Z`$ف< e
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}))