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.
Make text conditional on numeric value
-
- Posts: 6254
- Joined: Tue Mar 20, 2018 5:34 am
Re: Make text conditional on numeric value
Hello,
You can use Switch or IIF functions.
Thank you.
You can use Switch or IIF functions.
Thank you.