case based on range of numbers

[Bill_misc_IT]

I'm trying to get the following case statement to work, but have been unsuccessful. I have a field called total score and want another field to display Preferred, Needs Improvement, or Problem based on the score. I've created a calculation field with the following case statement, but a score of 69 returns "preferred". What am I doing wrong? Is the greater than/equal the wrong string?

Case ( 90≤total_score ≤ 100 ; "Preferred" ;70≤total_score ≤89 ; "Needs Improvement" ;"Problem Supplier")

[Digital Life]

I think it should be:

Case(total score > 89; "Preferred";

total_score > 69 and total_score < 90; "Needs Improvement";

"Problem Supplier)

[David Jondreau]

Greater/less than operators can't be used in a chain. Try:

Case(

total_score >= 90; "Preferred";

total_score >=70; "Needs Improvement";

"Problem Supplier"

)