Formula Help - IF Statements, RYG Balls

S Wood

Plain language requirement:

Average Score < 3 = Red

Average Score >4 = Green

Average Score and <4 = Yellow

My current formula: =IF([Average Score]@row < 3, "Red", IF([Average Score]@row > 4, "Green"), "Yellow")

I am getting error "Incorrect Argument Set"

Thanks!

Kimberly Loveless

I think you have an extra parenthesis in the middle . I think it should be

=IF([Average Score]@row < 3, "Red", IF([Average Score]@row > 4, "Green", "Yellow"))