EXCEL中如何按45天60天90天设收款提醒

2025-04-02 17:11:02

推荐回答（3个）

回答1：

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,"预警款","异常款")))

回答2：

C2公式：
=IF(Y2="N",LOOKUP(TODAY()-A2,{0,46,61,91},{"","异常款","预警款","高危"}),"")

回答3：

=IF(Y2="N",IF(TODAY()-A2>90,"高危",IF(TODAY()-A2>60,"预警款",IF(TODAY()-A2>40,"异常款",""))),"")