Assistance with IF formula

Mandy Bro

I'm working through the Capstone for the Core App Certification, and I'm stumped on one of the exercises.

Activity:

Use a nested-if formula to automate the RYG status balls in the "Status "column, depending on the "% Complete" for each request.

If a request is less than 70% complete, turn the "Status" column into a "Red" status ball

If a request is 70% or above and less than 100% complete, turn the "Status" column into a "Yellow" status ball

If a request is 100% complete, turn the "Status" column into a "Green" status ball

My Formula:

=IF([% Complete]@row < 70, "Red", IF(AND([% Complete]@row >= 70, [% Complete]@row < 100, "Yellow"), IF([% Complete]@row = 100, "Green")))

Issue:

All rows are returning "Red"

Carson Penticuff

10% = 0.10, 20% = 0.20, etc