Nested IF Statements for same date
I'm trying to create a Nested IF formula utilizing the status bars and due dates. What we're trying to say in English is:
If more than 5 days til due date = Green
If within 5 days of due date or equal to due date, = Yellow
If past due date = Red
I can get certain parts of the formula to work by themselves, but whenever I try to combine them into one cell I get back Unparseable.
The formula I have that works is:
=IF([Due Date]13 < TODAY(5), "Yellow", "")
=IF([Due Date]13 > TODAY(6), "Green", "Red")
When I combine them it breaks and I THINK it's because they contradict each other. As the 2nd one says if it's not greater than 6 days out it's Red, but the first one says if it's less than 5 it's Yellow. I can't figure out how to create this formula to do 3 different statuses.
Help Article Resources
Check out the Formula Handbook template!