下面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=](/uploads/image/z/3853570-58-0.jpg?t=%E4%B8%8B%E9%9D%A2excel%E5%87%BD%E6%95%B0%E7%9A%84%E5%90%AB%E4%B9%89%E6%98%AF+%3DIF%28M7%3D%22-%22%2C%22-%22%2CIF%28P7%3D%22-%22%2C%22-%22%2CIF%28N7%3D%22%22%2C%22-%22%2CROUND%28SUM%28M7%2A%281%2BP7%29%2FN7%29%2C1%29%29%29%29%E8%BF%99%E6%98%AFexcel2003%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%87%BD%E6%95%B0%2C%E8%AF%B7%E9%97%AE%E4%B8%8B%E9%9D%A2%E5%87%BD%E6%95%B0%E5%85%B7%E4%BD%93%E6%98%AF%E4%BB%80%E4%B9%88%E6%84%8F%E6%80%9D%2C%3DIF%28M7%3D%22-%22%2C%22-%22%2CIF%28P7%3D%22-%22%2C%22-%22%2CIF%28N7%3D%22%22%2C%22-%22%2CROUND%28SUM%28M7%2A%281%2BP7%29%2FN7%29%2C1%29%29%29%29)
下面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)