excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/13 06:20:20
excel中 IF(AM3

excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))
excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))

excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))
意思是:
如果AM3单元格不为空,返回“0 ”,否则:
(如果AJ3单元格不为空,返回AJ3单元格代表的日期与当前日期的间隔天数,否则返回“0 ”)