Make text conditional on numeric value

[crushin]

Hi, so I want to display text depending on the value in my JSON. I assumed I would do a conditional and use highlight text but that did not work it still only displayed the number value.

What I would like to display is
if value is between 90 -100 display 'EXCELLENT'
if value is between 75 -89 display 'GOOD'
if value is between 55 -74 display 'FAIR'
if value is <= 54 display 'POOR'

How do I make this happen?

Thanks.

[Lech Kulikowski]

Hello,

You can use Switch or IIF functions.

Thank you.