Why doesn't this IF statement Work

[maurices5000]

=IF((R9<=20),"Training Needed",IF(AND(R9>20,R9<42),"Good Job"),IF(0r(r9>=42,r9=0),"Outstanding"," "))

Below 20 "Training Needed"
Between 20 and 42 "Good Job"
42 and Over "Outstanding"
0 equal empty

How can i fix it? Thanks!

[TheNorm]

Get rid of the parenthesis after "Good Job".

[NBVC]

One closing parenthesis too many... and you had a 0 (zero) instead of the letter O in OR

=IF((R9<=20),"Training Needed",IF(AND(R9>20,R9<42),"Good Job",IF(OR(R9>=42,R9=0),"Outstanding"," ")))

[maurices5000]

Thanks! That did it!