Help with nested IF statement using AND

Katie Williams
Katie Williams ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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!

Formula snip.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!