excel2010,第一列计划达成时间,第二列实际达成时间,第三列当前时间,判...答:C12=IF(AND(B12="",A12-TODAY()>0),"未到期",IF(AND(B12="",A12-TODAY()<0),"未完成",IF(A12-B12<0,"逾期完成",IF(A12-B12>0,"提前完成","正常完成")))并设置条件格式,图中图就是设置的条件格式
excel if函数答:=IF(G8<>"",IF(F8=G8,"按时完成",IF(F8>G8,"提前完成","延迟完成")),IF(F8="持续执行","持续执行",IF(TODAY()>F8,"未完成","未到时间")))