Problems figuring out nested-IF formula

I'm having difficulty figuring out what is wrong with my formula in attempting to use a nested-if formula to automate the RYG light in the "Status" column, depending on the "% Complete" column.

Here is my formula: 

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3 => 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([% Complete]3 = 1.0, "Green")))

Can anyone assist? Thanks,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!