如何将else if语句转换为单个Excel嵌套语句

Question

我正在尝试创建一个包含以下IF语句的Excel IF函数：

If Date_Time_of_Request <= Authorization_Start_Date then REVIEW_TYPE = 'Prospective';
Else If Authorization_Start_Date <= Date_Time_of_Request <= Discharge_Date then REVIEW_TYPE = 'Concurrent';
Else If Date_Time_of_Request > = Discharge_Date then REVIEW_TYPE = 'Retrospective';
Else If Date_Time_of_Request > = Authorization_End_Date then REVIEW_TYPE = 'Retrospective';

我的尝试是：=IF(AS2 <= J2, "PROSPECTIVE", IF(AND(AS2 >= J2,AS2 <= V2),"CONCURRENT",IF(OR(AS2 > V2,AS2 > H2),"RETROSPECTIVE","UNKNOWN")))

但是，在大多数行中，V2都是空的，如果V2为空，我需要将它移到下一条语句。正如目前所写的，AS2 > V2在大多数情况下是真的(即使它是空的)。

Answer 1

类似于：

and(AS2>V2,LEN(V2)>0)