IF formula not working

kkinman

This seems to be a really basic formula I'm working on, but the result is only returning red for some reason. Can someone explain why other results might not be returning?

=IF([% Complete]@row < 70, "Red", IF([% Complete]@row = 100, "Green", "Yellow"))

Leibel S

@kkinman

I would assume that your % Complete column is percentage formatted so the value is actually in decimals (so 70 is really .7), your formula would need to be:

=IF([% Complete]@row < .7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))

kkinman

Just seeing this reply, thank you so much!