Simplifying a Case formula

[Bikeman17]

Hi there,

Here is a calc field that is not very efficient. Is there a way to simplify it? I mean one case for Black, Red and Yellow.

Case ( Color < 6 ; "Blue" ; Color = 6 ; "Black" ; Color = 7 ; "Black" ; Color = 8 ; "Black" ; Color = 9 ; "Red" ; Color = 10 ; "Red" ; Color = 11 ; "Red" ; Color = 12 ; "Red" ; Color = 13 ; "Red" ; Color = 14 ; "Yellow" ; Color = 15 ; "Yellow" ; Color = 16 ; "Yellow")

The calc result must be Text as you can see.

[comment]

How about:

Case (

Color < 6 ; "Blue" ;

Color < 9 ; "Black" ;

Color < 14 ; "Red" ;

"Yellow"

)

[Bikeman17]

Indeed !

Many thanks