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.