CASE FUNCTION HELP

[khank]

I have a trouble of expressing a condition within the CASE statement.

I have one number column "numtotal" with records numbers ranging from 0 through 27.

I have a second number column titled "range" where the function happens.

I'm wanting to range the numbers:

5 or less = "LOW"

16 or more = "HIGH"

6 through 15 = "BULLSEYE"

I believe the "CASE" function is the right function to use, but I can't seem to figure it. Help.

[Pbeyrouty]

In the range field did you try

case(

   numtotal < 6; "LOW";

   numtotal <16; "BULLSEYE";

   "HIGH"

)

The idea here is that Filemaker will check these in order. Once it finds a critera that matches it doesn't check the rest. Therefore if the number is 20 is won't match with the first to and go to the default value of HIGH.

Also be sure that the numtotal field is a number field and not a text field. I hope that helps.