下面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/05/04 01:12:24
下面excel函数的含义是 =IF(M7=

下面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)