求本EXCEL公式是否正确，关于EXCEL到期日期提醒
答案:6 悬赏:70 手机版
解决时间 2021-11-10 09:59
- 提问者网友：伴风望海
- 2021-11-09 22:50
求本EXCEL公式是否正确，关于EXCEL到期日期提醒
最佳答案
- 五星知识达人网友：野味小生
- 2021-11-09 23:01
公式中，文本外面要加双引号，公式变成
=IF(AND(B2-TODAY()<=30,B2-TODAY()>0),"将过期",IF(B2-TODAY()>30,"正常",IF(B2-TODAY()<=0,"过期","")))
=IF(AND(B2-TODAY()<=30,B2-TODAY()>0),"将过期",IF(B2-TODAY()>30,"正常",IF(B2-TODAY()<=0,"过期","")))
全部回答
- 1楼网友：鱼芗
- 2021-11-10 04:58
文本是不能直接用在公式中的，要用"",你的公式修改为如下即可
=IF(AND(B2-TODAY()<=30,B2-TODAY()>0),"将过期",IF(B2-TODAY()>30,"正常",IF(B2-TODAY()<=0,"过期","")))
=IF(AND(B2-TODAY()<=30,B2-TODAY()>0),"将过期",IF(B2-TODAY()>30,"正常",IF(B2-TODAY()<=0,"过期","")))
- 2楼网友：woshuo
- 2021-11-10 04:26
公式改为=IF(AND(B2-TODAY()<=30,B2-TODAY()>0),"将过期",IF(B2-TODAY()>30,"正常",IF(B2-TODAY()<=0,"过期","")))
- 3楼网友：从此江山别
- 2021-11-10 02:56
你设置的公式有二个地方出问题，一个是 文字 一定要用双引号，否则一个 是今天减B2
=IF(AND(TODAY()-B2<=30,TODAY()-B2>0),"将过期",IF(TODAY()-B2>30,"正常",IF(TODAY()-B2<=0,"过期","")))
=IF(AND(TODAY()-B2<=30,TODAY()-B2>0),"将过期",IF(TODAY()-B2>30,"正常",IF(TODAY()-B2<=0,"过期","")))
- 4楼网友：人间朝暮
- 2021-11-10 01:37
=IF(AND(B2-TODAY()<=30,B2-TODAY()>0),"将到期",IF(B2-TODAY()>30,"正常",IF(B2-TODAY()<=0,"过期","")))
- 5楼网友：神鬼未生
- 2021-11-10 00:07
1、将过期，过期等文本外加引号如："过期"
2、B2要输入正确格式的日期。
订正：
=IF(B2-TODAY()<=0,"过期",IF(TODAY()-B2>30,"正常","将过期"))
2、B2要输入正确格式的日期。
订正：
=IF(B2-TODAY()<=0,"过期",IF(TODAY()-B2>30,"正常","将过期"))
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯