Excel if 语句

Question

我在 Excel 电子表格中有这个简单的 if 语句，我想知道当单元格“V”列没有日期或为空白单元格时将单元格留空的正确方法。

=IF(V11>K11, "LATE","On-Time")

Answer 1

像这样

=IF(AND(LEN(V11)>0,OR(CELL("format",V11)={"D1","D2","D3","D4","D5"})),IF(V11>K11, "LATE","On-Time"),"not a valid date")

Answer 2

Excel 中的空白单元格 = 0，这是您想要的吗？

=IF(V11=0, 0, "cell in V column is not blank")