=IF(NOW()-B4>=15,"OK","警告 - 续订时间")
这是公式,但它可以保持空白直到在单元格 B4 中输入日期
谢谢
答案1
尝试=if(isblank(b4),"",IF(NOW()-B4>=15,"OK","Warning - Time to Renew"))
=IF(NOW()-B4>=15,"OK","警告 - 续订时间")
这是公式,但它可以保持空白直到在单元格 B4 中输入日期
谢谢
尝试=if(isblank(b4),"",IF(NOW()-B4>=15,"OK","Warning - Time to Renew"))