Help with nested IF statement using AND

Katie Williams

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!

Mike Wilday

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. 

L_123

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.

Katie Williams

Phew!  Thank you!