Nesting IF Formulas & Status Change

robyn.horn

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?

Sara Thibodeaux

It looks like you are missing "=" on the first check function. I am not super savy with formulas so there could be something else going on that is also an issue that I don't see. Hopefully that was the only thing. Hope this helps!

=IF([Expiration]23 = "", "Gray", IF([Expiration]23 < TODAY, "Red", IF([Expiration]23 < TODAY(30), "Yellow", IF([Expiration]23 = TODAY(30), "Green"))))