excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/06/28 01:05:28
excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))
意思是:
如果AM3单元格不为空,返回“0 ”,否则:
(如果AJ3单元格不为空,返回AJ3单元格代表的日期与当前日期的间隔天数,否则返回“0 ”)
如果AM3单元格不为空,返回“0 ”,否则:
(如果AJ3单元格不为空,返回AJ3单元格代表的日期与当前日期的间隔天数,否则返回“0 ”)
excel中 IF(AM3"","0",IF(AJ3"",DATEDIF(AJ3,TODAY(),"d"),"0"))
excel DATEDIF(TODAY(),A1,"d")问题
EXCEL的题目=IF(MOD(YEAR(TODAY()),4)=0,IF(MOD(YEAR(TODAY()),100)
IF(B3="","",IF(VALUE(DATEDIF(B3,C3,"D"))>=6575,"有资格","无资格"))
excel中没有datedif这个公式,在单元格输入公式=datedif(A1,TODAY(),"Y")结果返回错误值#
IF(AND(MONTH(A1)>=9,DAY(A1)>=1),DATEDIF(A1,TODAY(),"y")-1,DA
EXCEL中IF函数,
excel中,=IF(COUNTIF(A:A,B1)>0,B1,
excel中=IF(A2="","",IF(ISERROR(VLOOKUP(A2,SHEET1!A:B,2,0)),"查
excel中,函数=if(if-0.03
excel中公式IF(C7
excel中函数DATEDIF如何使用