EXCEL函数公式求助

把公式改为： =IF(AND(M2="",L2=""),IF(TODAY()>K2,"已延期",IF(K2-TODAY()K2,"已延期","已完成"),IF(M2>L2,"已延期","已完成"))) 即可