excel - Attempting to create excel database that flags a date (90, 120, 150) from a date column and produces an input "SOMETHING IS DUE" in another column
问题描述
The current IF statement I am attempting is:
=IF(D4<=TODAY()-90,"AWARD DUE",IF(D4>=TODAY()-91 AND D4<=TODAY()-120,"INPUTS DUE",IF(D4>=TODAY()-121 AND D4<=TODAY()-150,"PREPARE INPUTS","")))
but excel will not run the program and states, "There's a problem with this formula."
I am having trouble figuring out what the issue is and how to fix it. Any help in the right direction is appreciated. Thank you!
解决方案
推荐阅读
- hibernate - 我们是否可以在hibernate中使用自动增量以及手动插入主键
- android - Android - 在 Intent 中启动服务
- python - 使用 df.apply 调用与不同列关联的函数
- asp.net - 将 ADO.NET 实体数据模型添加到 Azure 函数项目会导致异常
- python - 在python dict中访问多个值
- java - Kafka Table 使用哪个客户端 ID
- html - 在 html 页面中显示 base64 编码图像时出错
- java - 同时在不同线程上处理目录中的文件 - Java Spring
- c++ - C ++中具有可变尺寸的二维数组
- python - 查找列中的最大数字