if(K8="2",if(G9=0,"",D9/G9),if(I9=0,"",F9/I9))
if(K8="2",if(G9=0,"",D9/G9),if(I9=0,"",F9/I9))
ROUND(IF(I9=1,IF(D9>0,H9/D9,0),0),
excle计算“=IF(E9="","",ROUND((F9+I9)*$K$595,
{=SMALL(IF(A3:G9>0,A3:G9),1)}谁可以给我解释一下这个公式中if内的具体含义?
=IF(OR(E9=0,H9=0),ROUNDUP((E9-G9)/H9,
=ROUND(E9*F9*G9/1000,
excel 中ROUND((G9*I9/H9),
=IF(OR(F9="",F9=0),"",TEXT(INT(F9),"
EXCEL表格函数公式问题(在线急等) =SUM(IF((sheet1!C2:C976=A4),sheet1!I2:I9
=IF(ISNA(VLOOKUP(K8,'1月'!D:E,2,0)),"",VLOOKUP(K8,'1月'!D:E,2,
公式=IF(L8"",YEAR(L8)-YEAR(K8),(YEAR(TODAY())-YEAR(K8)))的复制单元格
=IF(MID(F9,17,1)/2=TRUNC(MID(F9,17,1)/2),"女","男")这个公式怎么理解啊