B列记录劳动合同的到期日,希望在C列相邻单元格中显示提示,在到期前的30天内显示“即将到期”,在过期后显示“过期”。C2单元格的函数应表示为()。
- A、=IF(B2<T0nAY()+30,"即将到期","过期")
- B、=IF(B2<TODAY()+30,即将到期,过期)
- C、=IF(B2>TODAY(),"过期",IF(B2<=TODAY()+30,"即将到期")"")
- D、=IF(B2>TODAY(),IF(B2>TODAY()+30,"","即将到期"),"过期")
正确答案:D
答案解析:有
微信扫一扫手机做题