Help on RYG formula
I am tyring to write a formula for the RYG balls however I cannot figure out how to get yellow to show when I want it between numbers.
Red and Green I know as the below
=IF($[% Complete]3 < 0.5, "Red", IF($[% Complete]3 = 1, "Green"))
However how do I get yellow to show up when I want it >.50 and <.99