你好，我有下面的公式与日期字段。如果AP2是空白的，我如何添加一个错误消息到我的公式请？=IF(P2-AP2<365,"Death<1 year",Death >=one year")我尝试添加iferror和“日期缺失”）
=IF(P2-AP2<365,"Death<1 year",Death >=one year")
vyswwuz21#
=IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death<1 year","Death >= one year"))
1条答案
按热度按时间vyswwuz21#
=IF(ISBLANK(A1),"Date Missing",IF((B1-A1)<365,"Death<1 year","Death >= one year"))