Bring back a value based on condition of another cell

Carlos Yanes

Is there a way to integrate the yellow into the formula as well?

Paul Newcome

You are going to need to adjust your conditions or shift the location of the individual IF statements so that the yellow comes before the red.

Carlos Yanes

That's what I've been trying to do but I don't understand the formula to adjust it. :(

Paul Newcome

What do you want to adjust? Your criteria or the order?

Carlos Yanes

I think it's both?

If the original date is up to 10 days old past today's date then it should bring back yellow

If the original date is more than 10 days old past from today's date then it should bring back red

If the original date is original date is within 90 days (into the future) then green

If the original date is more than 90 days (into the future) then blue

Paul Newcome

=IF([Original Date]@row <> "", IF([Original Date]@row < TODAY(-10), "Red", IF([Original Date]@row <= TODAY(), "Yellow", IF([Original Date]@row <= TODAY(90), "Green", "Blue"))))

Carlos Yanes

Thanks @Paul Newcome that worked perfectly.

Can you help me understand the logic in the formula so I can learn for the future?