=IF($O$3="不锈钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.00005*
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/05/11 01:23:42
=IF($O$3="不锈钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.00005*(J8-20)),3),IF($O$3="碳钢"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="铜质"*$L$3="柴油",ROUND(H8*(1+0.0008*(I8-J8)+0.000053*(J8-20)),3),IF($O$3="铜质"*$L$3="汽油",ROUND(H8*(1+0.0012*(I8-J8)+0.000053*(J8-20)),3),IF($O$3="碳钢"*$L$3="汽油",ROUND(H8*(1+0.0012*(I8-J8)+0.000033*(J8-20)),3),IF($O$3="不锈钢"*$L$3="汽油",ROUND(H8*(1+0.0012*(I8-J8)+0.00005*(J8-20)),3))
)))))
)))))
excel?想干嘛?
=IF(OR((F8>I8:J8),(G8
在电子表格里这些是什么公式=IF(M8=1,SUM(G8+H8)/2,SUM(E8+F8+G8+H8+I8)/5)
excle函数=C8*D8+E8*F8+G8*H8+I8*J8如何计算,每个值都不一样的,我想要公式来简单来算?
=IF(AND(ABS(J8)
=IF(H8="",0,VLOOKUP(H8,'TABLE & LIST'!L:M,2,FALSE)) 以上公式的意思.
=ROUND(IF(J5
ROUND(IF(I12>=1,1),
IF(ROUND(A1,2)=3,0,ROUND(A1,2))这个函数是什么意思
=IF(MOD(ROW(),3),OFFSET(工资表!$A$1,(MOD(ROW()-1,3)>0)*ROUND(RO
英语翻译=IF((TODAY()-G350)/365=1,5,ROUND(5*ROUND(((DATE(2013,1,1
ROUND(IF(I9=1,IF(D9>0,H9/D9,0),0),
if语句excelif语句是=IF(OR(AB3="",X3=""),"",IF(X3="/",ROUND(1,2)&"