IF FORMULA HELP

proe

Here is my IF formula:

=IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 1, "Green", "Yellow"))

It works great for green and everything else not so much.

What I want it to do is calculate based off of percent complete.  so if less than 50% complete it should be red, if less than 75% yellow  everything else is green.  What have i done wrong?

 

Paul Newcome

Try writing it how you have it spelled out in words.

 

=IF([% Complete]3 < .5, "Red", IF([% Complete]3 < .75, "Yellow", "Green"))

 

Try thinking of it as a STATEMENT as opposed to a formula.