HELP Nested-if Formula
I'm trying to complete my certification and the following nested-if formula needs to be created:
"Use a nested-if formula to automate the RYG light in the "Status "column, depending on the "% Complete" for each request
If a request is less than 70% complete, turn the Status column "Red"
If a request is 70% or above and less than 100% complete, turn the Status column "Yellow"
If a request is 100% complete, turn the Status column "Green""
This is what i came up with (and other variations) but it doesn't work and I don't know why and I am going crazy! Help please!
=IF([Creative Request]4 < 0.7, "Red", IF(AND([Creative Request]4 >= 0.7, [Creative Request]4 < 1, "Yellow", IF([Creative Request]4 = 1, "Green"))))