Help with nested IF statement using AND
Hello Community,
I have created the below formula that SEEMS to be working but is not showing up with the color coding that typically happens when you have all your formula ducks in a row. It is returning a result, not an error, but I’m concerned there is still something missing since the text is showing up all black. See any issues?
=IF([% Complete]3 >= 0.9, "A", IF(AND([% Complete]3 < 0.9, [% Complete]3 >= 0.8), "B", IF(AND([% Complete]3 < 0.8, [% Complete]3 >= 0.7), "C", IF(AND([% Complete]3 < 0.7, [% Complete]3 >= 0.6), "D", IF([% Complete]3 < 0.6, "F", 0)))))
Thanks in advance!
Comments
-
Hi Katie,
If the formula is showing the right grade, then you should set up the conditional formatting with the Formatting Icon in the left-hand icon bar. Once you have the grade set up you want, then the coloring can be done based on the result in the formula. See this article on setting up conditional formatting.
-
past a certain length all formulas stop with the color coding. There is nothing to worry about the software is simply trying to reserve resources.
-
Phew! Thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!
