Symbols and percentage of

jezright · 09/07/22

I need your help to show status as Red, Green or Yellow using this criteria:

Green - 91-100

Yellow - 51 - 90

Red = 0-50

=Chris Palmer · 09/07/22

Try this and let me know if it works for you:

=IF(Percentage@row > 0.9, "Green", IF(Percentage@row > 0.89, "Yellow", IF(Percentage@row > 0.5, "Yellow", "Red")))

=Chris Palmer · 09/07/22

Try this and let me know if it works for you:

=IF(Percentage@row > 0.9, "Green", IF(Percentage@row > 0.89, "Yellow", IF(Percentage@row > 0.5, "Yellow", "Red")))

jezright · 09/07/22

Thank you so much. This worked

=Chris Palmer · 09/08/22

I'm happy this worked for you!

Best Answer