求Excel表格if条件公式

推荐回答

IF函数条件太多了，试试下面这个公式呢：=MID("一二三四",FIND(BJ2,"一二三四"),5-COUNTIF(BF2:BI2,">"&TODAY())-COUNTIF(BF2:BI2,"待定")-COUNTIF(BF2:BI2,"")-FIND(BJ2,"一二三四"))