Nested If formula for RYG

Laurie Bearden · 04/02/21

Good morning,

I'm having an issue with the following formula. The red and green come out, but the yellow comes back blank. Any assistance would be appreciated.

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row <= 0.07 - 1, "Yellow", IF([% Complete]@row = 1, "Green")))

Laurie Bearden · 04/02/21

I figured out the answer...I changed it to say

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))

I tried to find a way to delete my question, but maybe this will help someone else in the future 😉

Laurie Bearden · 04/02/21

I figured out the answer...I changed it to say

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))

I tried to find a way to delete my question, but maybe this will help someone else in the future 😉

Genevieve P. · 04/06/21

Thank you for posting your solution! 🙂I'm glad you were able to figure it out.

MDriggs · 07/07/22

Thank you for leaving this up! I just used it for an issue I was stuck on and it worked for me!

Laurie · 07/07/22

That's awesome!!! So glad I could help 😊

Best Answer