更新时间2019-09-11 17:38:41
提升 函数参数太多 =IF(B5=TODAY(),"今天到期",IF(B5-TODAY()<=30,"已过期 "&TODAY()-B5&"天","过期时间>30天",IF(B5-TODAY()<=30,"还有"&B5-TODAY()&"天到期","到期时间>30天"))) 谢谢
报错是因为第二个if多了一个参数。
=IF(
B5=TODAY(),
"今天到期",
IF(
B5-TODAY()<=30,
"已过期 "&TODAY()-B5&"天",
"过期时间>30天",
IF(
B5-TODAY()<=30,
"还有"&B5-TODAY()&"天到期",
"到期时间>30天"
)
)
)
下一篇:这是什么虫子?