How do I display a different symbol based on multiple values?

MikeRoss

I've searched the community and tried multiple formulas but I cannot seem to get this scenario to work.

I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display.

Scenario:

0% = Green

1% - 10% = Yellow

11% and over = Red

This is the formula I'm currently using. I get the Green and Yellow to show but not the Red. What am I doing wrong?

=IF(OR([% Not Achieved]# = 0), "Green", IF(OR([% Not Achieved]# >= 1, [% Not Achieved]# <= 10), "Yellow", IF(OR([% Not Achieved]# >= 11), "Red",)))

Andrée Starå

@MikeRoss

Try something like this instead.

=
IF([% Not Achieved]# = 0, "Green", 
IF(AND([% Not Achieved]# >= 0.01, [% Not Achieved]# <= 0.1), "Yellow", 
IF([% Not Achieved]# >= 0.11, "Red")))

Did that work?