Nesting IF Formulas & Status Change
I'm using a sheet to track status of contracts based on their expiration dates. The formula below is what I've set up to try to show that I want the status to be GRAY for no expiration date, RED if the contract has expired, YELLOW if there are 30 days or less until expiration, and GREEN if there are more than 30 days until the contract expires.
=IF([Expiration]23 "", "Gray", IF([Expiration]23 < TODAY, "Red", IF([Expiration]23 < TODAY(30), "Yellow", IF([Expiration]23 = TODAY(30), "Green"))))
It keeps giving me an UNPARSEABLE error message--not sure what I can/should do to fix it. Can anyone help?
Help Article Resources
Check out the Formula Handbook template!