excel中公式如何写?
发布网友
共1个回答
热心网友
=IF(COUNTIF(F:F,">="&I3)>0,"该保养啦","未到保养里程")
=IF(OR(COUNTIF(F:F,">="&I3)>0,DATEDIF(B4,TODAY(),"M")>=6),"该保养啦","未到保养里程")
追答B4是B列最小值。
