在EXCEL表中做应收款,想问下日期的条件提醒怎么设置,设置后怎样...答:在E3中输入公式 =IF(DATEDIF(B3,TODAY(),"d")>120,"预警款",IF(DATEDIF(B3,TODAY(),"d")>60,"异常款",""))你也可以通过设置条件格式来进行提示 在F3输入公式 =DATEDIF(B3,TODAY(),"d")然后在”格式“菜单下面选择”条件“格式,进行如下设置。设置完毕后,继续添加第二个条件。
EXCEL中如何按45天60天90天设收款提醒答:c2=IF(DATEDIF(A2,TODAY(),"d")>90,"高危",IF(DATEDIF(A2,TODAY(),"d")>60,"预警款","异常款"))在c2使用这个公式吧 =IF(Y2="y","",IF(DATEDIF(A2,TODAY(),"d")>90,"高危",IF(DATEDIF(A2,TODAY(),"d")>60,"预警款","异常款")))...
在excel的单元格中,按一定规则选择显示数据?答:=IF(COUNTIF(A1:A10,"超期"),"超期",IF(COUNTIF(A1:A10,"预警"),"预警",IF(COUNTIF(A1:A10,"正常"),"正常","完成")))
EXCEL函数如何设置,关于时间节点的公示答:E2输入:=IF(AND(C7<>"",C7<=B7),"已完成",IF(AND(C7<>"",C7<=D7),"延期完成",IF(OR(AND(TODAY()>B7,D7=""),AND(D7<>"",TODAY()>D7)),"未完成",IF(AND(B7-TODAY()<=7,B7-TODAY()>=0),"预警",IF(D7-TODAY()<=7,"延期预警","")))(对D列的理解,计划完成...