Nested IF statements with RYB symbols
I am trying to use RYG fill symbols in a nested if statement.
if % complete is 100% = Green
if % complete is less then 70% = Red
if % complete is greater then 70% and less then 100% = Yellow
Here is what I have, and I am getting a #INCORRECT ARGUMENT
=IF([% Complete]@row = 1, "Green", IF([% Complete]@row < 0.7, "Red", IF(AND([% Complete]@row >= 0.7, [% Complete]@row < 1, "Yellow"))))
Help Article Resources
Check out the Formula Handbook template!