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!
Aucun commentaire:
Enregistrer un commentaire