下面excel函数的含义是 =IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))这是excel2003表格的函数,请问下面函数具体是什么意思,=IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))

来源:学生作业帮助网 编辑:作业帮 时间:2024/07/15 03:53:56
下面excel函数的含义是 =IF(M7=
xRN@ a/1@%>@ 75Db! %A(F-cPgv/|&x"^lü73oeǕ^di_%H Zj/7֝Aw }C lm5v8Eo)\8 >cT5fZL#XIIv0=x b5M2+ܜG9ix5\h'qzsD7fT(*X8~$L4YK:S$pjJ"| EJV_@ h?gbP=Yj֬J]W3qg_\p`T9FrX-A3 oP`QE/qOCtdX2Ď@4 =#^׷Eǃt'9 OZ-

下面excel函数的含义是 =IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))这是excel2003表格的函数,请问下面函数具体是什么意思,=IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))
下面excel函数的含义是 =IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))
这是excel2003表格的函数,请问下面函数具体是什么意思,
=IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))

下面excel函数的含义是 =IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))这是excel2003表格的函数,请问下面函数具体是什么意思,=IF(M7="-","-",IF(P7="-","-",IF(N7="","-",ROUND(SUM(M7*(1+P7)/N7),1))))
如果M7显示的内容是-
那么公式结果就是-
如果不是,那么再判断P7内容是不是-
如果是,那么公式结果就是-
如果P7也不是,那就再判断N7是不是空值
如果是,就显示-
反之,就计算ROUND(SUM(M7*(1+P7)/N7)
ROUND(SUM(M7*(1+P7)/N7),1)的意思是
1加P7值后乘以M7的积,除以N7的结果,保留一位小数.
感觉sum是多余的,即这段可以修改为
ROUND(M7*(1+P7)/N7,1)