excel - 在空白单元格的情况下如何找到时间和提示消息之间的差异

Question

在这里我需要尝试找出创建日期和初始批准之间的差异。我试过以下公式

=IFERROR(IF(IF(AND(ISBLANK(B3),ISBLANK(C3)),"Enter dates"), IF(ISBLANK(B3),"Enter Created date"),IF(ISBLANK(C3),"Enter Initial Approval date",IF(C3<B3,"Enter correct date",C3-B3))),"Dates are Missing")

当创建的日期单元格为空时，公式不提示错误信息。

谁能帮帮我吗？

标签： excelif-statement

Answer 1

这对我有用：

=IFERROR(IF(AND(ISBLANK(B3),ISBLANK(C3)),"Enter dates",IF(ISBLANK(B3),"Enter Created date",IF(ISBLANK(C3),"Enter Initial Approval date",IF(C3<B3,"Enter correct date",C3-B3)))),"Dates are missing")

下面还有一个：

1. 检查一个或两个引用是否返回错误，如果是，则检查它是否是另一种错误的引用错误并报告丢失的引用或错误的引用；

2. 检查一个或两个引用中是否有数字，否则返回无效的引用。

   =IF(AND(ISERROR(B3),ISERROR(C3)),IF(AND(ERROR.TYPE(B3)=4,ERROR.TYPE(B3)=4),"Dates are missing","Erroneous dates"),IF(AND(ISBLANK(B3),ISBLANK(C3)),"Enter dates",IF(ISBLANK(B3),IF(ISERROR(C3),IF(ERROR.TYPE(C3)=4,"Initial approval date is missing","Erroneous initial approval date"),"Enter Created date"),IF(ISBLANK(C3),IF(ISERROR(B3),IF(ERROR.TYPE(B3)=4,"Created date is missing","Erroneous created date"),"Enter Initial Approval date"),IF(AND(ISNUMBER(B3),ISNUMBER(C3)),IF(C3<B3,"Enter correct date",C3-B3),IF(ISNUMBER(B3),"Invalid initial approval date",IF(ISNUMBER(C3),"Invalid created date","Invalid dates")))))))