Formula in Symbols column using IF... need help!

cmrapp

I'm attempting my first IF formula and am needing some help. Need to produce RYG in the symbols column based on a column we use for % Complete. Keep coming up with an error. What am I doing wrong?

=IF([Complete]@row = 0), "Red", IF([Complete]@row = .01 - .99), "Yellow", IF([Complete]@row = 1), "Green")))

Kelly Moore

Hey @cmrapp

You have misplaced parentheses. You are closing off the IF statements too early.

Try this

=IF(Complete@row = 0, "Red", IF(Complete@row = 1, "Green", "Yellow"))

With only 3 colors you only have to define two criteria. The third color will be anything leftover that is not defined in the first two criteria.

Does this work for you?

Kelly