Nested If formula for RYG
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")))
Best Answer

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 😉
Answers

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 😉

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

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

That's awesome!!! So glad I could help 😊
Help Article Resources
Categories
Check out the Formula Handbook template!